from dingtalk import SecretClient, AppKeyClient
from config.dingtalk_setting import AppKey, AppSecret, AgentId, role_hr, column
from common.libs.DataHelper import getCurrentTime, getCurrentDate
from werkzeug.datastructures import FileStorage
import collections
import datetime
import decimal
import math
import ast
from common.libs.Helper import dingtalkpost
import json, requests
import pandas as pd
import datacompy

a = FileStorage
##连接
client = SecretClient(AppKey, AppSecret)  # 新 access_token 获取方式

# 获得角色信息
# role = client.role.list()
# print(role)

# 获得角色中的用户id
# rolelist=client.role.simplelist(2831255724)["list"]
# print(rolelist)



# 获得某个流程详情
detail = client.bpms.processinstance_get("5sHPpblkSdaL3DSHSmFe4A01331677545067")
print(detail)


department = client.department.list(_id=184367930)
department = client.department.list_ids
print(department)



otherconstent = {
    "column_id_list": "395170037",
    "from_date": "2022-06-18 12:12:12",
    "to_date": "2022-07-07 12:12:12",
    "userid": "manager2655"
}
vacationconstent = {
    "from_date": "2022-06-18 12:12:12",
    "to_date": "2022-07-07 12:12:12",
    "leave_names": "事假,病假,产假,陪产假",
    "userid": "manager2655"
}

otherurl = 'https://oapi.dingtalk.com/topapi/attendance/getcolumnval'
vacationurl = 'https://oapi.dingtalk.com/topapi/attendance/getleavetimebynames'
other = dingtalkpost(otherurl, otherconstent)
vacation = dingtalkpost(vacationurl, vacationconstent)
print(other)

# late = sum(int(item["value"]) for item in other['result']['column_vals'][0]['column_vals'])
# leave = sum(int(item["value"]) for item in other['result']['column_vals'][1]['column_vals'])
# absent = sum(int(item["value"]) for item in other['result']['column_vals'][2]['column_vals'])
#
# shijia = sum(float(item["value"]) for item in vacation['result']['columns'][0]['columnvals'])
# bingjia = sum(float(item["value"]) for item in vacation['result']['columns'][1]['columnvals'])
# chanjia = sum(float(item["value"]) for item in vacation['result']['columns'][2]['columnvals'])
# peichanjia = sum(float(item["value"]) for item in vacation['result']['columns'][3]['columnvals'])

# f = {'errcode': 0, 'result': {'columns': [
#     {'alias': 'should_attendance_days', 'expression_id': 395163018, 'extension': 'null', 'id': 395170018,
#      'name': '应出勤天数', 'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'making_up_lack_times', 'expression_id': 395163019, 'extension': 'null', 'id': 395170019, 'name': '补卡次数',
#      'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'attendance_class', 'expression_id': 395163020, 'extension': 'null', 'id': 395170020, 'name': '出勤班次',
#      'status': 0, 'sub_type': 2, 'type': 0},
#     {'alias': 'attendance_days', 'expression_id': 395163021, 'extension': 'null', 'id': 395170021, 'name': '出勤天数',
#      'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'attendance_rest_days', 'expression_id': 395163022, 'extension': 'null', 'id': 395170022, 'name': '休息天数',
#      'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'attendance_work_time', 'expression_id': 395163023, 'extension': 'null', 'id': 395170023, 'name': '工作时长',
#      'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'late_times', 'expression_id': 395163024, 'extension': 'null', 'id': 395170024, 'name': '迟到次数',
#      'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'late_minute', 'expression_id': 395163025, 'extension': 'null', 'id': 395170025, 'name': '迟到时长',
#      'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'serious_late_times', 'expression_id': 395163026, 'extension': 'null', 'id': 395170026, 'name': '严重迟到次数',
#      'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'serious_late_minute', 'expression_id': 395163027, 'extension': 'null', 'id': 395170027, 'name': '严重迟到时长',
#      'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'absenteeism_late_times', 'expression_id': 395163028, 'extension': 'null', 'id': 395170028,
#      'name': '旷工迟到次数', 'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'leave_early_times', 'expression_id': 395163029, 'extension': 'null', 'id': 395170029, 'name': '早退次数',
#      'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'leave_early_minute', 'expression_id': 395163030, 'extension': 'null', 'id': 395170030, 'name': '早退时长',
#      'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'on_work_lack_card_times', 'expression_id': 395163031, 'extension': 'null', 'id': 395170031,
#      'name': '上班缺卡次数', 'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'off_work_lack_card_times', 'expression_id': 395163032, 'extension': 'null', 'id': 395170032,
#      'name': '下班缺卡次数', 'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'absenteeism_days', 'expression_id': 395163033, 'extension': 'null', 'id': 395170033, 'name': '旷工天数',
#      'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'business_trip_time', 'expression_id': 395163034, 'extension': 'null', 'id': 395170034, 'name': '出差时长',
#      'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'out_time', 'expression_id': 395163035, 'extension': 'null', 'id': 395170035, 'name': '外出时长', 'status': 0,
#      'sub_type': 0, 'type': 0}, {'alias': 'leave_', 'name': '事假', 'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'leave_', 'name': '调休', 'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'leave_', 'name': '病假', 'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'leave_', 'name': '年假', 'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'leave_', 'name': '产假', 'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'leave_', 'name': '陪产假', 'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'leave_', 'name': '婚假', 'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'leave_', 'name': '例假', 'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'leave_', 'name': '丧假', 'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'leave_', 'name': '哺乳假', 'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'overtime_approve_count', 'expression_id': 395163037, 'extension': 'null', 'id': 395170037,
#      'name': '加班-审批单统计', 'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'overtime_工作日加班', 'expression_id': 395163038, 'extension': 'null', 'id': 395170038, 'name': '工作日加班',
#      'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'overtime_休息日加班', 'expression_id': 395163039, 'extension': 'null', 'id': 395170039, 'name': '休息日加班',
#      'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'overtime_节假日加班', 'expression_id': 395163040, 'extension': 'null', 'id': 395170040, 'name': '节假日加班',
#      'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'attend_result', 'expression_id': 395163041, 'extension': 'null', 'id': 395170041, 'name': '考勤结果',
#      'status': 0, 'sub_type': 1, 'type': 0},
#     {'alias': 'plan_detail', 'expression_id': 395163042, 'extension': 'null', 'id': 395170042, 'name': '班次',
#      'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': '1_on_duty_user_check_time', 'expression_id': 395163043, 'extension': 'null', 'id': 395170043,
#      'name': '上班1打卡时间', 'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': '1_on_duty_user_check_result', 'expression_id': 395163044, 'extension': 'null', 'id': 395170044,
#      'name': '上班1打卡结果', 'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': '1_off_duty_user_check_time', 'expression_id': 395163045, 'extension': 'null', 'id': 395170045,
#      'name': '下班1打卡时间', 'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': '1_off_duty_user_check_result', 'expression_id': 395163046, 'extension': 'null', 'id': 395170046,
#      'name': '下班1打卡结果', 'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': '2_on_duty_user_check_time', 'expression_id': 395163047, 'extension': 'null', 'id': 395170047,
#      'name': '上班2打卡时间', 'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': '2_on_duty_user_check_result', 'expression_id': 395163048, 'extension': 'null', 'id': 395170048,
#      'name': '上班2打卡结果', 'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': '2_off_duty_user_check_time', 'expression_id': 395163049, 'extension': 'null', 'id': 395170049,
#      'name': '下班2打卡时间', 'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': '2_off_duty_user_check_result', 'expression_id': 395163050, 'extension': 'null', 'id': 395170050,
#      'name': '下班2打卡结果', 'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': '3_on_duty_user_check_time', 'expression_id': 395163051, 'extension': 'null', 'id': 395170051,
#      'name': '上班3打卡时间', 'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': '3_on_duty_user_check_result', 'expression_id': 395163052, 'extension': 'null', 'id': 395170052,
#      'name': '上班3打卡结果', 'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': '3_off_duty_user_check_time', 'expression_id': 395163053, 'extension': 'null', 'id': 395170053,
#      'name': '下班3打卡时间', 'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': '3_off_duty_user_check_result', 'expression_id': 395163054, 'extension': 'null', 'id': 395170054,
#      'name': '下班3打卡结果', 'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'attendance_approve', 'expression_id': 395163055, 'extension': 'null', 'id': 395170055, 'name': '关联的审批单',
#      'status': 0, 'sub_type': 0, 'type': 0},
#     {'alias': 'absenteeism_late_times', 'expression_id': 395163056, 'extension': 'null', 'id': 395170056,
#      'name': '旷工迟到天数', 'status': 0, 'sub_type': 0, 'type': 0}]}, 'request_id': '16lzwqamec70k'}

#
# a = {'errcode': 0, 'result': {'column_vals': [{'column_vals': [{'date': '2022-06-18 00:00:00', 'value': '0'},
#                                                                {'date': '2022-06-19 00:00:00', 'value': '0'},
#                                                                {'date': '2022-06-20 00:00:00', 'value': '0'},
#                                                                {'date': '2022-06-21 00:00:00', 'value': '0'},
#                                                                {'date': '2022-06-22 00:00:00', 'value': '0'},
#                                                                {'date': '2022-06-23 00:00:00', 'value': '0'},
#                                                                {'date': '2022-06-24 00:00:00', 'value': '0'},
#                                                                {'date': '2022-06-25 00:00:00', 'value': '0'},
#                                                                {'date': '2022-06-26 00:00:00', 'value': '0'},
#                                                                {'date': '2022-06-27 00:00:00', 'value': '0'},
#                                                                {'date': '2022-06-28 00:00:00', 'value': '0'},
#                                                                {'date': '2022-06-29 00:00:00', 'value': '0'},
#                                                                {'date': '2022-06-30 00:00:00', 'value': '0'},
#                                                                {'date': '2022-07-01 00:00:00', 'value': '0'},
#                                                                {'date': '2022-07-02 00:00:00', 'value': '0'},
#                                                                {'date': '2022-07-03 00:00:00', 'value': '0'},
#                                                                {'date': '2022-07-04 00:00:00', 'value': '0'},
#                                                                {'date': '2022-07-05 00:00:00', 'value': '0'},
#                                                                {'date': '2022-07-06 00:00:00', 'value': '0'},
#                                                                {'date': '2022-07-07 00:00:00', 'value': '0'}],
#                                                'column_vo': {'id': 395170024}}, {
#                                                   'column_vals': [{'date': '2022-06-18 00:00:00', 'value': '0'},
#                                                                   {'date': '2022-06-19 00:00:00', 'value': '0'},
#                                                                   {'date': '2022-06-20 00:00:00', 'value': '0'},
#                                                                   {'date': '2022-06-21 00:00:00', 'value': '0'},
#                                                                   {'date': '2022-06-22 00:00:00', 'value': '0'},
#                                                                   {'date': '2022-06-23 00:00:00', 'value': '0'},
#                                                                   {'date': '2022-06-24 00:00:00', 'value': '0'},
#                                                                   {'date': '2022-06-25 00:00:00', 'value': '0'},
#                                                                   {'date': '2022-06-26 00:00:00', 'value': '0'},
#                                                                   {'date': '2022-06-27 00:00:00', 'value': '0'},
#                                                                   {'date': '2022-06-28 00:00:00', 'value': '0'},
#                                                                   {'date': '2022-06-29 00:00:00', 'value': '0'},
#                                                                   {'date': '2022-06-30 00:00:00', 'value': '0'},
#                                                                   {'date': '2022-07-01 00:00:00', 'value': '0'},
#                                                                   {'date': '2022-07-02 00:00:00', 'value': '0'},
#                                                                   {'date': '2022-07-03 00:00:00', 'value': '0'},
#                                                                   {'date': '2022-07-04 00:00:00', 'value': '0'},
#                                                                   {'date': '2022-07-05 00:00:00', 'value': '0'},
#                                                                   {'date': '2022-07-06 00:00:00', 'value': '0'},
#                                                                   {'date': '2022-07-07 00:00:00', 'value': '0'}],
#                                                   'column_vo': {'id': 395170029}}, {
#                                                   'column_vals': [{'date': '2022-06-18 00:00:00', 'value': '0'},
#                                                                   {'date': '2022-06-19 00:00:00', 'value': '0'},
#                                                                   {'date': '2022-06-20 00:00:00', 'value': '1'},
#                                                                   {'date': '2022-06-21 00:00:00', 'value': '1'},
#                                                                   {'date': '2022-06-22 00:00:00', 'value': '1'},
#                                                                   {'date': '2022-06-23 00:00:00', 'value': '1'},
#                                                                   {'date': '2022-06-24 00:00:00', 'value': '1'},
#                                                                   {'date': '2022-06-25 00:00:00', 'value': '0'},
#                                                                   {'date': '2022-06-26 00:00:00', 'value': '0'},
#                                                                   {'date': '2022-06-27 00:00:00', 'value': '1'},
#                                                                   {'date': '2022-06-28 00:00:00', 'value': '1'},
#                                                                   {'date': '2022-06-29 00:00:00', 'value': '1'},
#                                                                   {'date': '2022-06-30 00:00:00', 'value': '1'},
#                                                                   {'date': '2022-07-01 00:00:00', 'value': '0'},
#                                                                   {'date': '2022-07-02 00:00:00', 'value': '0'},
#                                                                   {'date': '2022-07-03 00:00:00', 'value': '0'},
#                                                                   {'date': '2022-07-04 00:00:00', 'value': '0'},
#                                                                   {'date': '2022-07-05 00:00:00', 'value': '0'},
#                                                                   {'date': '2022-07-06 00:00:00', 'value': '0'},
#                                                                   {'date': '2022-07-07 00:00:00', 'value': '0'}],
#                                                   'column_vo': {'id': 395170033}}]}, 'request_id': '15rru0rdn6h2n'}


from common.libs.Helper import dateafter

# a=dateafter(5)
# print(a)
#
# userinfo={"name":"关卓然","mobile":"15513863020","department":['699351474'],"userid":"666666"}
#
# a = client.user.create(userinfo)
# print(a)
#
# userinfo = {"userid": '762' }
# url = 'https://oapi.dingtalk.com/topapi/v2/user/get'
# res = dingtalkpost(url, userinfo)
# print(res)
#
# dict4 = {'name': 'Tom', 'age': 18}
# del dict4['name']  # 删除字典，如果键不存在，返回错误
# print(dict4)

# from common.libs.Helper import dingtalkpost
#
# content = {
#     "process_instance_id": "grBcZfW0QyOWH42WWIO7OQ01331663316982"
# }
#
content1 = {
    "vacation_source": "all",
    "op_userid": "056411420820728054"
}
url = "https://oapi.dingtalk.com/topapi/attendance/vacation/type/list"
a = dingtalkpost(url=url, content=content1)
print(a)

# y=client.user.get("760")
# print(y["department"][0])
#
# g = {'errcode': 0, 'errmsg': 'ok', 'process_instance': {'attached_process_instance_ids': [], 'biz_action': 'NONE',
#                                                         'business_id': '202209151637000230252',
#                                                         'create_time': '2022-09-15 16:37:23',
#                                                         'finish_time': '2022-09-15 16:37:40', 'form_component_values': [
#         {'component_type': 'TextField', 'id': 'TextField-K2AD4O5B', 'name': '调岗人员', 'value': '关卓然'},
#         {'component_type': 'TextField', 'id': 'TextField_JQB7SVTZVI80', 'name': '工号', 'value': '739'},
#         {'component_type': 'DDDateField', 'id': 'DDDateField_6KWO88TOPZS0', 'name': '生效日期', 'value': '2022-09-07'},
#         {'component_type': 'DepartmentField',
#          'ext_value': '[{"number":3,"itemId":"678126725","name":"信息技术部","id":"678126725"}]',
#          'id': 'DepartmentField_1URPJ48EKRXC0', 'name': '调出部门', 'value': '信息技术部'},
#         {'component_type': 'TextField', 'id': 'TextField_1CNOLJT610U80', 'name': '原岗位', 'value': '副经理'},
#         {'component_type': 'DepartmentField',
#          'ext_value': '[{"number":6,"itemId":"617053092","name":"人力资源部（太原）","id":"617053092"}]',
#          'id': 'DepartmentField_20UGADKBPIU80', 'name': '调入部门', 'value': '人力资源部（太原）'},
#         {'component_type': 'TextField', 'id': 'TextField_1W736DV25JVK0', 'name': '调整后岗位', 'value': '经理'},
#         {'component_type': 'TextareaField', 'id': 'TextareaField_2H7WU7BD1FK0', 'name': '备注',
#          'value': '测试备注测试备注测试备注测试备注'},
#         {'component_type': 'DDAttachment', 'id': 'DDAttachment_1ZA1V163Y03K0', 'name': '附件', 'value': 'null'}],
#                                                         'operation_records': [
#                                                             {'date': '2022-09-15 16:37:23', 'operation_result': 'NONE',
#                                                              'operation_type': 'START_PROCESS_INSTANCE',
#                                                              'userid': '056411420820728054'},
#                                                             {'date': '2022-09-15 16:37:40', 'operation_result': 'AGREE',
#                                                              'operation_type': 'EXECUTE_TASK_NORMAL', 'remark': '测试',
#                                                              'userid': '056411420820728054'}],
#                                                         'originator_dept_id': '678126725',
#                                                         'originator_dept_name': '信息技术板块-信息技术部',
#                                                         'originator_userid': '056411420820728054', 'result': 'agree',
#                                                         'status': 'COMPLETED', 'tasks': [
#         {'activity_id': '1918_5cd3', 'create_time': '2022-09-15 16:37:24', 'finish_time': '2022-09-15 16:37:40',
#          'task_result': 'AGREE', 'task_status': 'COMPLETED', 'taskid': '76032798829',
#          'url': 'aflow.dingtalk.com?procInsId=cDnnqECfRdG2Dgk65vQ_XA01331663231043&taskId=76032798829&businessId=202209151637000230252',
#          'userid': '056411420820728054'}], 'title': '关卓然提交的人员调岗申请'}, 'request_id': '16lzywgqauaif'}
#
# u = {'attached_process_instance_ids': {}, 'biz_action': 'NONE', 'business_id': '202209152141000591452',
#      'create_time': '2022-09-15 21:42:00', 'finish_time': '2022-09-15 21:42:04', 'form_component_values': {
#         'form_component_value_vo': [
#             {'component_type': 'TextField', 'id': 'TextField-K2AD4O5B', 'name': '调岗人员', 'value': '测试'},
#             {'component_type': 'TextField', 'id': 'TextField_JQB7SVTZVI80', 'name': '工号', 'value': '762'},
#             {'component_type': 'DDDateField', 'id': 'DDDateField_6KWO88TOPZS0', 'name': '生效日期', 'value': '2022-09-25'},
#             {'component_type': 'DepartmentField', 'ext_value': '[{"number":11,"name":"人力资源板块","id":"184365915"}]',
#              'id': 'DepartmentField_1URPJ48EKRXC0', 'name': '调出部门', 'value': '人力资源板块'},
#             {'component_type': 'TextField', 'id': 'TextField_1CNOLJT610U80', 'name': '原岗位', 'value': '副总经理'},
#             {'component_type': 'DepartmentField', 'ext_value': '[{"number":4,"name":"证券部","id":"184363996"}]',
#              'id': 'DepartmentField_20UGADKBPIU80', 'name': '调入部门', 'value': '证券部'},
#             {'component_type': 'TextField', 'id': 'TextField_1W736DV25JVK0', 'name': '调整后岗位', 'value': '总经理助理'},
#             {'component_type': 'TextareaField', 'id': 'TextareaField_2H7WU7BD1FK0', 'name': '备注', 'value': '123'},
#             {'component_type': 'DDAttachment', 'id': 'DDAttachment_1ZA1V163Y03K0', 'name': '附件', 'value': '[]'}]},
#      'operation_records': {'operation_records_vo': [
#          {'date': '2022-09-15 21:41:59', 'operation_result': 'NONE', 'operation_type': 'START_PROCESS_INSTANCE',
#           'userid': '739'},
#          {'date': '2022-09-15 21:42:03', 'operation_result': 'AGREE', 'operation_type': 'EXECUTE_TASK_NORMAL',
#           'userid': '056411420820728054'}]}, 'originator_dept_id': '184365915', 'originator_dept_name': '人力资源板块',
#      'originator_userid': '739', 'result': 'agree', 'status': 'COMPLETED', 'tasks': {'task_top_vo': [
#         {'create_time': '2022-09-15 21:42:00', 'finish_time': '2022-09-15 21:42:04', 'task_result': 'AGREE',
#          'task_status': 'COMPLETED', 'taskid': '76037514754', 'userid': '056411420820728054'}]},
#      'title': '关卓然提交的人员调岗申请'}
#
# o = {'errcode': 0, 'errmsg': 'ok', 'process_instance': {'attached_process_instance_ids': [], 'biz_action': 'NONE',
#                                                         'business_id': '202209161629000425141',
#                                                         'create_time': '2022-09-16 16:29:42', 'form_component_values': [
#         {'component_type': 'InnerContactField',
#          'ext_value': '[{"emplId":"056411420820728054","itemId":"056411420820728054","name":"关卓然","selectDeptName":"","avatar":"https://static.dingtalk.com/media/lQDPDhs_pA2_ONnNAwzNAwywYKeWgcO_-coCOPE9oUBhAA_780_780.jpg_60x60q90.jpg?bizType=avatar","selectDeptId":""}]',
#          'id': 'InnerContactField_HH3BT94PYFC0', 'name': '离职人员', 'value': '关卓然'},
#         {'component_type': 'TextField', 'id': 'TextField_154IHEGN46800', 'name': '工号', 'value': '739'},
#         {'component_type': 'DepartmentField',
#          'ext_value': '[{"number":3,"itemId":"678126725","name":"信息技术部","id":"678126725"}]',
#          'id': 'DepartmentField_B4M4Y8N4TLS0', 'name': '部门', 'value': '信息技术部'},
#         {'component_type': 'TextField', 'id': 'TextField_E4JTM052T4G0', 'name': '岗位', 'value': '副经理'},
#         {'component_type': 'DDDateField', 'id': 'DDDateField_1WXX0DYQDRSW0', 'name': '入职日期', 'value': '2022-09-16'},
#         {'component_type': 'DDDateField', 'id': 'DDDateField_1SJ7CAMVBDZ40', 'name': '离职日期', 'value': '2022-09-17'},
#         {'component_type': 'DDSelectField', 'id': 'DDSelectField_1B17FRX395S00', 'name': '邮箱是否保留', 'value': 'null'},
#         {'component_type': 'NumberField', 'id': 'NumberField_1W6JACRVG5280', 'name': '个月', 'value': 'null'},
#         {'component_type': 'DDSelectField', 'id': 'DDSelectField_B70HNNAMEFS0', 'name': ' 是否购买笔记本电脑', 'value': 'null'},
#         {'component_type': 'TextField', 'id': 'TextField_G6GBIMK76Y00', 'name': '具体信息', 'value': 'null'},
#         {'component_type': 'DDDateField', 'id': 'DDDateField_COGO9JXVC2G0', 'name': '考勤截止日期', 'value': 'null'},
#         {'component_type': 'DDDateRangeField', 'id': 'DDDateRangeField_792I58LQLBS0', 'name': '["笔记本电脑购置时间","截止时间"]',
#          'value': 'null'},
#         {'component_type': 'MoneyField', 'id': 'MoneyField_10KJ2NX9ESGG0', 'name': '笔记本电脑残余价值金额（元）', 'value': 'null'},
#         {'component_type': 'SignatureField',
#          'ext_value': '{"watermask":"仅限[员工离职申请]使用","sticker":{"time":1663316984124,"username":"关卓然"},"time":1663316984124}',
#          'id': 'SignatureField_21CDFA0TUR5S0', 'name': '员工签字',
#          'value': 'https://down-cdn.dingtalk.com/ddmedia/iAEKAqNwbmcDBgTMvAXM0gbaACOEAaQhM_W4AqqBODY7TOgeOanzA88AAAGDRWr6DgTOAAXicgcACAA.png'},
#         {'component_type': 'DDSelectField', 'ext_value': '{"label":"否","key":"option_1"}',
#          'id': 'DDSelectField_1VGZMTG8UIBK0', 'name': '是否需要离职证明', 'value': '否'}], 'operation_records': [
#         {'date': '2022-09-16 16:29:42', 'operation_result': 'NONE', 'operation_type': 'START_PROCESS_INSTANCE',
#          'userid': '056411420820728054'}], 'originator_dept_id': '678126725', 'originator_dept_name': '信息技术板块-信息技术部',
#                                                         'originator_userid': '056411420820728054', 'result': '',
#                                                         'status': 'RUNNING', 'tasks': [
#         {'activity_id': '1442_9cb0', 'create_time': '2022-09-16 16:29:43', 'task_result': 'NONE',
#          'task_status': 'RUNNING', 'taskid': '76006313890',
#          'url': 'aflow.dingtalk.com?procInsId=grBcZfW0QyOWH42WWIO7OQ01331663316982&taskId=76006313890&businessId=202209161629000425141',
#          'userid': '056411420820728054'}], 'title': '关卓然提交的员工离职申请'}, 'request_id': '15r5gilnit8bx'}


i = {'errcode': 0, 'result': {'columns': [
    {'alias': '1_off_duty_user_check_result', 'expression_id': 88116663, 'extension': 'null', 'id': 88118663,
     'name': '下班1打卡结果', 'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': '1_off_duty_user_check_time', 'expression_id': 88116662, 'extension': 'null', 'id': 88118662,
     'name': '下班1打卡时间', 'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': '1_on_duty_user_check_result', 'expression_id': 104920751, 'extension': 'null', 'id': 88118661,
     'name': '上班1打卡结果', 'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': '1_on_duty_user_check_time', 'expression_id': 112184361, 'extension': 'null', 'id': 88118660,
     'name': '上班1打卡时间', 'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': '2_off_duty_user_check_result', 'expression_id': 88116667, 'extension': 'null', 'id': 88118667,
     'name': '下班2打卡结果', 'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': '2_off_duty_user_check_time', 'expression_id': 88116666, 'extension': 'null', 'id': 88118666,
     'name': '下班2打卡时间', 'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': '2_on_duty_user_check_result', 'expression_id': 104920752, 'extension': 'null', 'id': 88118665,
     'name': '上班2打卡结果', 'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': '2_on_duty_user_check_time', 'expression_id': 112186193, 'extension': 'null', 'id': 88118664,
     'name': '上班2打卡时间', 'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': '3_off_duty_user_check_result', 'expression_id': 88116671, 'extension': 'null', 'id': 88118671,
     'name': '下班3打卡结果', 'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': '3_off_duty_user_check_time', 'expression_id': 88116670, 'extension': 'null', 'id': 88118670,
     'name': '下班3打卡时间', 'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': '3_on_duty_user_check_result', 'expression_id': 88116669, 'extension': 'null', 'id': 88118669,
     'name': '上班3打卡结果', 'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': '3_on_duty_user_check_time', 'expression_id': 88116668, 'extension': 'null', 'id': 88118668,
     'name': '上班3打卡时间', 'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'absenteeism_days', 'expression_id': 118925334, 'extension': 'null', 'id': 88118650, 'name': '旷工天数',
     'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'absenteeism_late_times', 'expression_id': 88116673, 'extension': 'null', 'id': 88118673,
     'name': '旷工迟到天数', 'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'absenteeism_late_times', 'expression_id': 118925331, 'extension': 'null', 'id': 88118645,
     'name': '旷工迟到次数', 'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'attendance_approve', 'expression_id': 88116672, 'extension': 'null', 'id': 88118672, 'name': '关联的审批单',
     'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'attendance_class', 'expression_id': 112186255, 'extension': 'null', 'id': 88118637, 'name': '出勤班次',
     'status': 0, 'sub_type': 2, 'type': 0},
    {'alias': 'attendance_days', 'expression_id': 118925327, 'extension': 'null', 'id': 88118638, 'name': '出勤天数',
     'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'attendance_rest_days', 'expression_id': 118925328, 'extension': 'null', 'id': 88118639, 'name': '休息天数',
     'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'attendance_work_time', 'expression_id': 112186256, 'extension': 'null', 'id': 88118640, 'name': '工作时长',
     'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'attend_result', 'expression_id': 118925336, 'extension': 'null', 'id': 88118658, 'name': '考勤结果',
     'status': 0, 'sub_type': 1, 'type': 0},
    {'alias': 'business_trip_time', 'expression_id': 104930541, 'extension': 'null', 'id': 88118651, 'name': '出差时长',
     'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'fee_overtime_休息日', 'expression_id': 660956183, 'extension': 'null', 'id': 660963183, 'name': '休息日（转加班费）',
     'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'fee_overtime_工作日', 'expression_id': 660956182, 'extension': 'null', 'id': 660963182, 'name': '工作日（转加班费）',
     'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'fee_overtime_节假日', 'expression_id': 660956184, 'extension': 'null', 'id': 660963184, 'name': '节假日（转加班费）',
     'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'late_minute', 'expression_id': 95062101, 'extension': 'null', 'id': 88118642, 'name': '迟到时长',
     'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'late_times', 'expression_id': 118925329, 'extension': 'null', 'id': 88118641, 'name': '迟到次数',
     'status': 0, 'sub_type': 0, 'type': 0}, {'alias': 'leave_', 'name': '事假', 'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'leave_', 'name': '病假', 'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'leave_', 'name': '年假', 'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'leave_', 'name': '婚假', 'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'leave_', 'name': '加班调休', 'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'leave_', 'name': '出差调休', 'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'leave_', 'name': '产假', 'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'leave_', 'name': '丧假', 'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'leave_', 'name': '上海、江苏办公室年假', 'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'leave_', 'name': '深圳办公室年假', 'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'leave_', 'name': '深圳办公室调休', 'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'leave_early_minute', 'expression_id': 95062106, 'extension': 'null', 'id': 88118647, 'name': '早退时长',
     'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'leave_early_times', 'expression_id': 118925332, 'extension': 'null', 'id': 88118646, 'name': '早退次数',
     'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'making_up_lack_times', 'expression_id': 88116636, 'extension': 'null', 'id': 88118636, 'name': '补卡次数',
     'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'off_work_lack_card_times', 'expression_id': 88116649, 'extension': 'null', 'id': 88118649,
     'name': '下班缺卡次数', 'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'on_work_lack_card_times', 'expression_id': 118925333, 'extension': 'null', 'id': 88118648,
     'name': '上班缺卡次数', 'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'out_time', 'expression_id': 95062110, 'extension': 'null', 'id': 88118652, 'name': '外出时长', 'status': 0,
     'sub_type': 0, 'type': 0},
    {'alias': 'overtime_approve_count', 'expression_id': 95062112, 'extension': 'null', 'id': 88118654,
     'name': '加班-审批单统计', 'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'overtime_duration', 'expression_id': 660956181, 'extension': 'null', 'id': 660963181, 'name': '加班总时长',
     'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'overtime_休息日加班', 'expression_id': 95062114, 'extension': 'null', 'id': 88118656, 'name': '休息日加班',
     'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'overtime_工作日加班', 'expression_id': 95062113, 'extension': 'null', 'id': 88118655, 'name': '工作日加班',
     'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'overtime_节假日加班', 'expression_id': 95062115, 'extension': 'null', 'id': 88118657, 'name': '节假日加班',
     'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'plan_detail', 'expression_id': 112184360, 'extension': 'null', 'id': 88118659, 'name': '班次', 'status': 0,
     'sub_type': 0, 'type': 0},
    {'alias': 'rest_overtime_休息日', 'expression_id': 660956186, 'extension': 'null', 'id': 660963186, 'name': '休息日（转调休）',
     'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'rest_overtime_工作日', 'expression_id': 660956185, 'extension': 'null', 'id': 660963185, 'name': '工作日（转调休）',
     'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'rest_overtime_节假日', 'expression_id': 660956187, 'extension': 'null', 'id': 660963187, 'name': '节假日（转调休）',
     'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'serious_late_minute', 'expression_id': 95062103, 'extension': 'null', 'id': 88118644, 'name': '严重迟到时长',
     'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'serious_late_times', 'expression_id': 118925330, 'extension': 'null', 'id': 88118643, 'name': '严重迟到次数',
     'status': 0, 'sub_type': 0, 'type': 0},
    {'alias': 'should_attendance_days', 'expression_id': 118925326, 'extension': 'null', 'id': 88118635,
     'name': '应出勤天数', 'status': 0, 'sub_type': 0, 'type': 0}]}, 'request_id': '15s7myedh6x0m'}

time = datetime.datetime.now()
print(time)

stime = "2022-11-01 12:12:12"
etime = "2022-12-01 12:12:12"
userid = "056411420820728054"

# otherconstent = {
#     "column_id_list": column["应出勤天数"] + "," + column["出勤天数"] + "," + column[
#         "旷工天数"] + "," + column["休息日（转加班费）"] + "," + column[
#                           "工作日（转加班费）"] + "," + column["节假日（转加班费）"] + "," + column["迟到次数"] + "," + column[
#                           "补卡次数"] + "," + column["下班缺卡次数"] + "," + column[
#                           "上班缺卡次数"] + "," + column["加班-审批单统计"] + "," + column[
#                           "休息日加班"] + "," + column["工作日加班"] + "," + column["节假日加班"] + "," + column[
#                           "休息日（转调休）"] + "," + column["工作日（转调休）"] + "," + column["节假日（转调休）"] + "," + column[
#                           "严重迟到次数"],
#     "from_date": stime,
#     "to_date": etime,
#     "userid": userid
# }

vacationconstent = {
    "from_date": stime,
    "to_date": etime,
    "leave_names": "事假,年假,婚假,病假,产假,陪产假",
    "userid": userid
}
#
# url1 = "https://oapi.dingtalk.com/topapi/attendance/getcolumnval"
# a1 = dingtalkpost(url=url1, content=otherconstent)
# print(a1)


other = {'errcode': 0, 'result': {'column_vals': [{'column_vals': [{'date': '2022-11-01 00:00:00', 'value': '1.0'},
                                                                   {'date': '2022-11-02 00:00:00', 'value': '1.0'},
                                                                   {'date': '2022-11-03 00:00:00', 'value': '1.0'},
                                                                   {'date': '2022-11-04 00:00:00', 'value': '1.0'},
                                                                   {'date': '2022-11-05 00:00:00', 'value': '0.0'},
                                                                   {'date': '2022-11-06 00:00:00', 'value': '0.0'},
                                                                   {'date': '2022-11-07 00:00:00', 'value': '1.0'},
                                                                   {'date': '2022-11-08 00:00:00', 'value': '1.0'},
                                                                   {'date': '2022-11-09 00:00:00', 'value': '1.0'},
                                                                   {'date': '2022-11-10 00:00:00', 'value': '1.0'},
                                                                   {'date': '2022-11-11 00:00:00', 'value': '1.0'},
                                                                   {'date': '2022-11-12 00:00:00', 'value': '0.0'},
                                                                   {'date': '2022-11-13 00:00:00', 'value': '0.0'},
                                                                   {'date': '2022-11-14 00:00:00', 'value': '1.0'},
                                                                   {'date': '2022-11-15 00:00:00', 'value': '1.0'},
                                                                   {'date': '2022-11-16 00:00:00', 'value': '1.0'},
                                                                   {'date': '2022-11-17 00:00:00', 'value': '1.0'},
                                                                   {'date': '2022-11-18 00:00:00', 'value': '1.0'},
                                                                   {'date': '2022-11-19 00:00:00', 'value': '0.0'},
                                                                   {'date': '2022-11-20 00:00:00', 'value': '0.0'},
                                                                   {'date': '2022-11-21 00:00:00', 'value': '1.0'},
                                                                   {'date': '2022-11-22 00:00:00', 'value': '1.0'},
                                                                   {'date': '2022-11-23 00:00:00', 'value': '1.0'},
                                                                   {'date': '2022-11-24 00:00:00', 'value': '1.0'},
                                                                   {'date': '2022-11-25 00:00:00', 'value': '1.0'},
                                                                   {'date': '2022-11-26 00:00:00', 'value': '0.0'},
                                                                   {'date': '2022-11-27 00:00:00', 'value': '0.0'},
                                                                   {'date': '2022-11-28 00:00:00', 'value': '1.0'},
                                                                   {'date': '2022-11-29 00:00:00', 'value': '1.0'},
                                                                   {'date': '2022-11-30 00:00:00', 'value': '1.0'},
                                                                   {'date': '2022-12-01 00:00:00', 'value': '1.0'}],
                                                   'column_vo': {'id': 88118635}}, {
                                                      'column_vals': [{'date': '2022-11-01 00:00:00', 'value': '1'},
                                                                      {'date': '2022-11-02 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-03 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-04 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-05 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-06 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-07 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-08 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-09 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-10 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-11 00:00:00', 'value': '1'},
                                                                      {'date': '2022-11-12 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-13 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-14 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-15 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-16 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-17 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-18 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-19 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-20 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-21 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-22 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-23 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-24 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-25 00:00:00', 'value': '1'},
                                                                      {'date': '2022-11-26 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-27 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-28 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-29 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-30 00:00:00', 'value': '1'},
                                                                      {'date': '2022-12-01 00:00:00', 'value': '0'}],
                                                      'column_vo': {'id': 88118636}}, {
                                                      'column_vals': [{'date': '2022-11-01 00:00:00', 'value': '1.0'},
                                                                      {'date': '2022-11-02 00:00:00', 'value': '1.0'},
                                                                      {'date': '2022-11-03 00:00:00', 'value': '1.0'},
                                                                      {'date': '2022-11-04 00:00:00', 'value': '1.0'},
                                                                      {'date': '2022-11-05 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-06 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-07 00:00:00', 'value': '1.0'},
                                                                      {'date': '2022-11-08 00:00:00', 'value': '1.0'},
                                                                      {'date': '2022-11-09 00:00:00', 'value': '1.0'},
                                                                      {'date': '2022-11-10 00:00:00', 'value': '1.0'},
                                                                      {'date': '2022-11-11 00:00:00', 'value': '1.0'},
                                                                      {'date': '2022-11-12 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-13 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-14 00:00:00', 'value': '1.0'},
                                                                      {'date': '2022-11-15 00:00:00', 'value': '1.0'},
                                                                      {'date': '2022-11-16 00:00:00', 'value': '1.0'},
                                                                      {'date': '2022-11-17 00:00:00', 'value': '1.0'},
                                                                      {'date': '2022-11-18 00:00:00', 'value': '1.0'},
                                                                      {'date': '2022-11-19 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-20 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-21 00:00:00', 'value': '1.0'},
                                                                      {'date': '2022-11-22 00:00:00', 'value': '1.0'},
                                                                      {'date': '2022-11-23 00:00:00', 'value': '1.0'},
                                                                      {'date': '2022-11-24 00:00:00', 'value': '1.0'},
                                                                      {'date': '2022-11-25 00:00:00', 'value': '1.0'},
                                                                      {'date': '2022-11-26 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-27 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-28 00:00:00', 'value': '1.0'},
                                                                      {'date': '2022-11-29 00:00:00', 'value': '1.0'},
                                                                      {'date': '2022-11-30 00:00:00', 'value': '1.0'},
                                                                      {'date': '2022-12-01 00:00:00', 'value': '1.0'}],
                                                      'column_vo': {'id': 88118638}}, {
                                                      'column_vals': [{'date': '2022-11-01 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-02 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-03 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-04 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-05 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-06 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-07 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-08 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-09 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-10 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-11 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-12 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-13 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-14 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-15 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-16 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-17 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-18 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-19 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-20 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-21 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-22 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-23 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-24 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-25 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-26 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-27 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-28 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-29 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-30 00:00:00', 'value': '0'},
                                                                      {'date': '2022-12-01 00:00:00', 'value': '0'}],
                                                      'column_vo': {'id': 88118641}}, {
                                                      'column_vals': [{'date': '2022-11-01 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-02 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-03 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-04 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-05 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-06 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-07 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-08 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-09 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-10 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-11 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-12 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-13 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-14 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-15 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-16 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-17 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-18 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-19 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-20 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-21 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-22 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-23 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-24 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-25 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-26 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-27 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-28 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-29 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-30 00:00:00', 'value': '0'},
                                                                      {'date': '2022-12-01 00:00:00', 'value': '0'}],
                                                      'column_vo': {'id': 88118643}}, {
                                                      'column_vals': [{'date': '2022-11-01 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-02 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-03 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-04 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-05 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-06 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-07 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-08 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-09 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-10 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-11 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-12 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-13 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-14 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-15 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-16 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-17 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-18 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-19 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-20 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-21 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-22 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-23 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-24 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-25 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-26 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-27 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-28 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-29 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-30 00:00:00', 'value': '0'},
                                                                      {'date': '2022-12-01 00:00:00', 'value': '0'}],
                                                      'column_vo': {'id': 88118648}}, {
                                                      'column_vals': [{'date': '2022-11-01 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-02 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-03 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-04 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-05 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-06 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-07 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-08 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-09 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-10 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-11 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-12 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-13 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-14 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-15 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-16 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-17 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-18 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-19 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-20 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-21 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-22 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-23 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-24 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-25 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-26 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-27 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-28 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-29 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-30 00:00:00', 'value': '0'},
                                                                      {'date': '2022-12-01 00:00:00', 'value': '0'}],
                                                      'column_vo': {'id': 88118649}}, {
                                                      'column_vals': [{'date': '2022-11-01 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-02 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-03 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-04 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-05 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-06 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-07 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-08 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-09 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-10 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-11 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-12 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-13 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-14 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-15 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-16 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-17 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-18 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-19 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-20 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-21 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-22 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-23 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-24 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-25 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-26 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-27 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-28 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-29 00:00:00', 'value': '0'},
                                                                      {'date': '2022-11-30 00:00:00', 'value': '0'},
                                                                      {'date': '2022-12-01 00:00:00', 'value': '0'}],
                                                      'column_vo': {'id': 88118650}}, {
                                                      'column_vals': [{'date': '2022-11-01 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-02 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-03 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-04 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-05 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-06 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-07 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-08 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-09 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-10 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-11 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-12 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-13 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-14 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-15 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-16 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-17 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-18 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-19 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-20 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-21 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-22 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-23 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-24 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-25 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-26 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-27 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-28 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-29 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-30 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-12-01 00:00:00', 'value': '0.0'}],
                                                      'column_vo': {'id': 88118654}}, {
                                                      'column_vals': [{'date': '2022-11-01 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-02 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-03 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-04 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-05 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-06 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-07 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-08 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-09 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-10 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-11 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-12 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-13 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-14 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-15 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-16 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-17 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-18 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-19 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-20 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-21 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-22 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-23 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-24 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-25 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-26 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-27 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-28 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-29 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-30 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-12-01 00:00:00', 'value': '0.0'}],
                                                      'column_vo': {'id': 88118655}}, {
                                                      'column_vals': [{'date': '2022-11-01 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-02 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-03 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-04 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-05 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-06 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-07 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-08 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-09 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-10 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-11 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-12 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-13 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-14 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-15 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-16 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-17 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-18 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-19 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-20 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-21 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-22 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-23 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-24 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-25 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-26 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-27 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-28 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-29 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-30 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-12-01 00:00:00', 'value': '0.0'}],
                                                      'column_vo': {'id': 88118656}}, {
                                                      'column_vals': [{'date': '2022-11-01 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-02 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-03 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-04 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-05 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-06 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-07 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-08 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-09 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-10 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-11 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-12 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-13 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-14 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-15 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-16 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-17 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-18 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-19 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-20 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-21 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-22 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-23 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-24 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-25 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-26 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-27 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-28 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-29 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-30 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-12-01 00:00:00', 'value': '0.0'}],
                                                      'column_vo': {'id': 88118657}}, {
                                                      'column_vals': [{'date': '2022-11-01 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-02 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-03 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-04 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-05 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-06 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-07 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-08 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-09 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-10 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-11 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-12 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-13 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-14 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-15 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-16 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-17 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-18 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-19 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-20 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-21 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-22 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-23 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-24 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-25 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-26 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-27 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-28 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-29 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-30 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-12-01 00:00:00', 'value': '0.0'}],
                                                      'column_vo': {'id': 660963182}}, {
                                                      'column_vals': [{'date': '2022-11-01 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-02 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-03 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-04 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-05 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-06 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-07 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-08 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-09 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-10 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-11 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-12 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-13 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-14 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-15 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-16 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-17 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-18 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-19 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-20 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-21 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-22 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-23 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-24 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-25 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-26 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-27 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-28 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-29 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-30 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-12-01 00:00:00', 'value': '0.0'}],
                                                      'column_vo': {'id': 660963183}}, {
                                                      'column_vals': [{'date': '2022-11-01 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-02 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-03 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-04 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-05 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-06 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-07 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-08 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-09 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-10 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-11 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-12 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-13 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-14 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-15 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-16 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-17 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-18 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-19 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-20 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-21 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-22 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-23 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-24 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-25 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-26 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-27 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-28 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-29 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-30 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-12-01 00:00:00', 'value': '0.0'}],
                                                      'column_vo': {'id': 660963184}}, {
                                                      'column_vals': [{'date': '2022-11-01 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-02 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-03 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-04 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-05 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-06 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-07 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-08 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-09 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-10 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-11 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-12 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-13 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-14 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-15 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-16 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-17 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-18 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-19 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-20 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-21 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-22 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-23 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-24 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-25 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-26 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-27 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-28 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-29 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-30 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-12-01 00:00:00', 'value': '0.0'}],
                                                      'column_vo': {'id': 660963185}}, {
                                                      'column_vals': [{'date': '2022-11-01 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-02 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-03 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-04 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-05 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-06 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-07 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-08 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-09 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-10 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-11 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-12 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-13 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-14 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-15 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-16 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-17 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-18 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-19 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-20 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-21 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-22 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-23 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-24 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-25 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-26 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-27 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-28 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-29 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-30 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-12-01 00:00:00', 'value': '0.0'}],
                                                      'column_vo': {'id': 660963186}}, {
                                                      'column_vals': [{'date': '2022-11-01 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-02 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-03 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-04 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-05 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-06 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-07 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-08 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-09 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-10 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-11 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-12 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-13 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-14 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-15 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-16 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-17 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-18 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-19 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-20 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-21 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-22 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-23 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-24 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-25 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-26 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-27 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-28 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-29 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-11-30 00:00:00', 'value': '0.0'},
                                                                      {'date': '2022-12-01 00:00:00', 'value': '0.0'}],
                                                      'column_vo': {'id': 660963187}}]}, 'request_id': '16kcppb0j6hb8'}


def dic_get_key(val, dic):
    for key, value in dic.items():
        if val == value:
            return key


print(len(other['result']['column_vals']))

userid = "739"
for i in range(len(other['result']['column_vals'][0]['column_vals'])):
    otherdic = {}
    for item in range(len(other['result']['column_vals'])):
        colid = dic_get_key(str(other['result']['column_vals'][int(item)]['column_vo']['id']), column)
        colvalue = other['result']['column_vals'][int(item)]['column_vals'][int(i)]['value']
        coldate = other['result']['column_vals'][int(item)]['column_vals'][int(i)]['date']
        checkid = userid + coldate[0:10].replace('-', '')
        otherdic.update({"id": checkid})
        otherdic.update({"date": coldate})
        otherdic.update({colid: colvalue})
    print(otherdic)

# for item in other['result']['column_vals'][0]['column_vals'])

# for i in other['result']['column_vals']:
#     columnid=i['column_vo']['id']
#
#     for item in i['column_vals']:
#         columnvalue=item["value"]
#
#         print(columnvalue)


#
# {'errcode': 0, 'result': [
#     {'freedom_leave': True, 'hours_in_per_day': 800, 'leave_code': '1c4aaf17-3b56-4cd2-8857-4cc38c4b07a8',
#      'leave_name': '事假', 'leave_time_ceil': False, 'leave_view_unit': 'hour', 'natural_day_leave': 'false',
#      'paid_leave': False, 'source': 'inner', 'when_can_leave': 'entry'},
#     {'freedom_leave': True, 'hours_in_per_day': 800, 'leave_code': '17b5b57b-47ea-4f3d-99c7-5576f473971b',
#      'leave_name': '病假', 'leave_time_ceil': False, 'leave_view_unit': 'hour', 'natural_day_leave': 'false',
#      'paid_leave': False, 'source': 'inner', 'when_can_leave': 'entry'},
#     {'freedom_leave': True, 'hours_in_per_day': 800, 'leave_code': 'db5dcbdd-a24f-4c41-a21d-b04b2812a412',
#      'leave_name': '年假', 'leave_time_ceil': False, 'leave_view_unit': 'day', 'natural_day_leave': 'false',
#      'paid_leave': False, 'source': 'inner', 'when_can_leave': 'entry'},
#     {'freedom_leave': False, 'leave_code': 'be30e0a7-b432-4e01-8330-44bd5c575321', 'leave_name': '婚假',
#      'leave_view_unit': 'day', 'source': 'inner'},
#     {'freedom_leave': True, 'leave_code': '3f8d4ce8-9565-49a3-a631-cccf10b98d62', 'leave_name': '产假',
#      'leave_time_ceil': False, 'leave_view_unit': 'day', 'natural_day_leave': 'false', 'paid_leave': False,
#      'source': 'inner', 'when_can_leave': 'entry'},
#     {'freedom_leave': True, 'leave_code': 'bd4dadea-da78-4bda-a784-94679cdcee2b', 'leave_hour_ceil': '',
#      'leave_name': '陪产假', 'leave_view_unit': 'day', 'natural_day_leave': 'true', 'paid_leave': True, 'source': 'inner',
#      'when_can_leave': 'entry'},
#     {'freedom_leave': True, 'leave_code': '08a7bb8d-72b6-4386-a20b-36ac6c37b9bc', 'leave_hour_ceil': '',
#      'leave_name': '丧假', 'leave_view_unit': 'day', 'natural_day_leave': 'false', 'paid_leave': False, 'source': 'inner',
#      'when_can_leave': 'entry'}, {'biz_type': 'lieu_leave', 'freedom_leave': False, 'hours_in_per_day': 800,
#                                   'leave_code': '77e8bf6f-9ec1-4c2b-b46b-ebe531c6cea6', 'leave_hour_ceil': '',
#                                   'leave_name': '加班调休', 'leave_time_ceil_min_unit': 'hour', 'leave_view_unit': 'hour',
#                                   'natural_day_leave': 'false', 'paid_leave': True, 'source': 'inner',
#                                   'validity_type': 'relative_time', 'validity_value': '90', 'when_can_leave': 'entry'},
#     {'freedom_leave': True, 'leave_code': '80fe4a5d-4928-4cbc-8c48-22da3304099a', 'leave_hour_ceil': '',
#      'leave_name': '出差调休', 'leave_view_unit': 'day', 'natural_day_leave': 'false', 'paid_leave': True,
#      'source': 'inner', 'when_can_leave': 'entry'},
#     {'biz_type': 'general_leave', 'freedom_leave': False, 'hours_in_per_day': 800,
#      'leave_code': 'fbcdd6a3-1cd7-4aab-93e1-0be651b3e2de', 'leave_hour_ceil': '', 'leave_name': '上海、江苏办公室年假',
#      'leave_time_ceil_min_unit': 'hour', 'leave_view_unit': 'hour', 'natural_day_leave': 'false', 'paid_leave': True,
#      'source': 'inner', 'visibility_rules': [{'type': 'dept', 'visible': ['225589401', '663222129']}],
#      'when_can_leave': 'formal'},
#     {'freedom_leave': True, 'leave_code': '4cfc782a-d506-4f79-8ae5-6fb3ee738d17', 'leave_hour_ceil': '',
#      'leave_name': '深圳办公室年假', 'leave_view_unit': 'halfDay', 'natural_day_leave': 'false', 'paid_leave': True,
#      'source': 'inner', 'visibility_rules': [{'type': 'dept', 'visible': ['609770351']}], 'when_can_leave': 'entry'},
#     {'biz_type': 'general_leave', 'freedom_leave': False, 'leave_code': '147d0a5d-63a9-4f9c-a420-0a2f306c55d8',
#      'leave_hour_ceil': '', 'leave_name': '深圳办公室调休', 'leave_view_unit': 'halfDay', 'natural_day_leave': 'false',
#      'paid_leave': True, 'source': 'inner', 'visibility_rules': [{'type': 'dept', 'visible': ['609770351']}],
#      'when_can_leave': 'entry'}], 'success': True, 'request_id': '15sel0spu4l4x'}
#
# content6 = {
#     "op_userid": "056411420820728054",
#     "leave_quotas": [
#         {
#             "start_time": 1641030274000,
#             "reason": "管理员导入",
#             "quota_num_per_day": 100,
#             "quota_cycle": "2022",
#             "end_time": 1672479874000,
#             "leave_code": "694e75be-c4bc-4547-ab54-796175eba2b0",
#             "quota_num_per_hour": 100,
#             "userid": "056411420820728054"
#         }
#     ],
# }
# ooo = requests.post("http://101.132.227.54:82/api/check/test", data=content6)
# resdata = ooo.json()
# print(resdata)
#
# uu = {"msg": {"errcode": 0, "result": {"biz_type": "general_leave", "freedom_leave": false, "hours_in_per_day": 1000,
#                                        "leave_certificate": {"duration": 1, "enable": false,
#                                                              "prompt_information": "请假信息", "unit": "hour"},
#                                        "leave_code": "694e75be-c4bc-4547-ab54-796175eba2b0", "leave_hour_ceil": "up",
#                                        "leave_name": "员工年假", "leave_time_ceil": false,
#                                        "leave_time_ceil_min_unit": "hour", "leave_view_unit": "day",
#                                        "max_leave_time": 1, "min_leave_hour": 2, "natural_day_leave": true,
#                                        "paid_leave": true,
#                                        "submit_time_rule": {"enable_time_limit": false, "time_type": "before",
#                                                             "time_unit": "day", "time_value": 1},
#                                        "visibility_rules": [{"type": "staff", "visible": ["056411420820728054"]}],
#                                        "when_can_leave": "entry"}, "success": true, "request_id": "15rur27wzju42"},
#       "type": {"when_can_leave": "entry", "leave_time_ceil_min_unit": "hour",
#                "visibility_rules": {"visible": "056411420820728054", "type": "staff"}, "leave_view_unit": "day",
#                "leave_name": "员工年假", "biz_type": "general_leave", "min_leave_hour": "2",
#                "extras": "{\"validity_type\":\"absolute_time\",\"validity_value\":\"12-31\"}", "freedom_leave": "false",
#                "submit_time_rule": {"enable_time_limit": "false", "time_type": "before", "time_value": "1",
#                                     "time_unit": "day"}, "op_userid": "056411420820728054", "natural_day_leave": "true",
#                "paid_leave": "true", "leave_time_ceil": "false", "hours_in_per_day": "1000", "leave_hour_ceil": "up",
#                "leave_certificate": {"duration": "1", "unit": "hour", "enable": "false", "prompt_information": "请假信息"},
#                "max_leave_time": "1"}}

# todaystr = "2023-01-18"
# todaydatetime=datetime.datetime.strptime(todaystr, '%Y-%m-%d')
# today = datetime.datetime.date(todaydatetime)

todaystr = "2023-02-01"
# today = datetime.date.today()
todaydatetime = datetime.datetime.strptime(todaystr, '%Y-%m-%d')
today = datetime.datetime.date(todaydatetime)
first = today.replace(day=1)
# last_month = first - datetime.timedelta(days=1)
etime = today - datetime.timedelta(days=1)
stime = etime.strftime("%Y-%m") + "-01"
# stime = last_month.strftime("%Y-%m") + "-01"
print(stime)
print(etime)

content = {
    "language": "zh_CN",
    "dept_id": 822311415
}
url = "https://oapi.dingtalk.com/topapi/v2/department/get"
a = dingtalkpost(url=url, content=content)
if 'dept_manager_userid_list' in a['result']:
    print(a['result']['dept_manager_userid_list'][0])

c = [
    {
        "children": [
            {
                "id": 4,
                "label": "朱忠义"
            },
            {
                "id": 14,
                "label": "张新海"
            },
            {
                "id": 28,
                "label": "王永红"
            },
            {
                "id": 111,
                "label": "郝志勇"
            },
            {
                "id": 138,
                "label": "王振国"
            },
            {
                "id": 588,
                "label": "江东"
            },
            {
                "id": 648,
                "label": "蔺万焕"
            },
            {
                "id": 649,
                "label": "郑伟"
            },
            {
                "id": 650,
                "label": "张路"
            },
            {
                "id": 857,
                "label": "卓佳"
            }
        ],
        "id": 184326905,
        "label": "公司高管"
    },
    {
        "children": [
            {
                "children": [
                    {
                        "id": 535,
                        "label": "陈龙真"
                    }
                ],
                "id": 599687120,
                "label": "分拣业务部"
            },
            {
                "children": [],
                "id": 726949499,
                "label": "上海公司财务部"
            },
            {
                "children": [
                    {
                        "id": 437,
                        "label": "蒋琼"
                    }
                ],
                "id": 727114254,
                "label": "上海公司人力行政部"
            }
        ],
        "id": 225589401,
        "label": "上海公司"
    },
    {
        "children": [
            {
                "id": 2,
                "label": "贾俊亭"
            },
            {
                "id": 12,
                "label": "张同军"
            }
        ],
        "id": 594563453,
        "label": "顾问委员会"
    },
    {
        "children": [
            {
                "children": [
                    {
                        "id": 542,
                        "label": "李鑫"
                    },
                    {
                        "id": 565,
                        "label": "罗晓明"
                    }
                ],
                "id": 629858524,
                "label": "深圳公司人力资源部"
            },
            {
                "children": [],
                "id": 629875479,
                "label": "深圳公司财务部"
            }
        ],
        "id": 609770351,
        "label": "深圳公司"
    },
    {
        "children": [
            {
                "children": [],
                "id": 726834872,
                "label": "江苏公司财务部"
            },
            {
                "children": [
                    {
                        "id": 786,
                        "label": "王金"
                    }
                ],
                "id": 726869749,
                "label": "江苏公司生产管理"
            },
            {
                "children": [
                    {
                        "id": 734,
                        "label": "潘爱祥"
                    }
                ],
                "id": 727168113,
                "label": "江苏公司供应链管理部"
            },
            {
                "children": [],
                "id": 727209040,
                "label": "江苏公司人力行政部"
            }
        ],
        "id": 663222129,
        "label": "江苏公司"
    },
    {
        "children": [],
        "id": 699351474,
        "label": "待入职人员"
    },
    {
        "children": [
            {
                "children": [],
                "id": 726991737,
                "label": "山东公司行政管理部"
            },
            {
                "children": [],
                "id": 727170344,
                "label": "山东公司财务部"
            }
        ],
        "id": 704687549,
        "label": "山东公司"
    },
    {
        "children": [
            {
                "children": [
                    {
                        "children": [
                            {
                                "id": 139,
                                "label": "李晨宇"
                            },
                            {
                                "id": 213,
                                "label": "王皓石"
                            },
                            {
                                "id": 290,
                                "label": "李彩峰"
                            },
                            {
                                "id": 408,
                                "label": "尹磊"
                            },
                            {
                                "id": 472,
                                "label": "冯曙东"
                            },
                            {
                                "id": 487,
                                "label": "张鹏"
                            },
                            {
                                "id": 614,
                                "label": "王博"
                            }
                        ],
                        "id": 598001853,
                        "label": "海外规划技术部"
                    },
                    {
                        "children": [],
                        "id": 598179827,
                        "label": "马来西亚"
                    },
                    {
                        "children": [],
                        "id": 598929873,
                        "label": "泰国"
                    },
                    {
                        "children": [],
                        "id": 599108735,
                        "label": "海外销售（泰国）"
                    },
                    {
                        "children": [
                            {
                                "id": 125,
                                "label": "梁茂强"
                            },
                            {
                                "id": 287,
                                "label": "陈鹏州"
                            }
                        ],
                        "id": 599241830,
                        "label": "海外销售一部"
                    },
                    {
                        "children": [],
                        "id": 695940125,
                        "label": "海外员工"
                    }
                ],
                "id": 580603377,
                "label": "海外业务部"
            }
        ],
        "id": 704776545,
        "label": "海外业务板块"
    },
    {
        "children": [
            {
                "children": [
                    {
                        "children": [
                            {
                                "id": 608,
                                "label": "刘冰"
                            },
                            {
                                "id": 613,
                                "label": "郭广友"
                            },
                            {
                                "id": 652,
                                "label": "何红平"
                            },
                            {
                                "id": 660,
                                "label": "王锐"
                            },
                            {
                                "id": 692,
                                "label": "姜山"
                            },
                            {
                                "id": 725,
                                "label": "彭钰莹"
                            },
                            {
                                "id": 729,
                                "label": "龙勇"
                            },
                            {
                                "id": 730,
                                "label": "陈跃楠"
                            }
                        ],
                        "id": 653587527,
                        "label": "新能源解决方案中心"
                    },
                    {
                        "children": [
                            {
                                "id": 507,
                                "label": "王连浩"
                            },
                            {
                                "id": 638,
                                "label": "伍超"
                            },
                            {
                                "id": 691,
                                "label": "查润春"
                            },
                            {
                                "id": 785,
                                "label": "项昊淼"
                            }
                        ],
                        "id": 654409369,
                        "label": "新能源销售部"
                    }
                ],
                "id": 654016468,
                "label": "新能源事业部"
            }
        ],
        "id": 704784543,
        "label": "新能源板块"
    },
    {
        "children": [
            {
                "children": [
                    {
                        "id": 50079,
                        "label": "胡小波"
                    },
                    {
                        "id": 50082,
                        "label": "黄舜"
                    }
                ],
                "id": 719505949,
                "label": "上海海登"
            },
            {
                "children": [
                    {
                        "children": [
                            {
                                "children": [
                                    {
                                        "id": 350,
                                        "label": "智杰阳"
                                    }
                                ],
                                "id": 719767565,
                                "label": "海登项目管理部"
                            },
                            {
                                "children": [
                                    {
                                        "id": 50041,
                                        "label": "任良云"
                                    },
                                    {
                                        "id": 50042,
                                        "label": "赵永君"
                                    },
                                    {
                                        "id": 50043,
                                        "label": "张忠华"
                                    },
                                    {
                                        "id": 50044,
                                        "label": "孙国欣"
                                    },
                                    {
                                        "id": 50046,
                                        "label": "张鑫宇"
                                    },
                                    {
                                        "id": 50047,
                                        "label": "高晓波"
                                    }
                                ],
                                "id": 719891363,
                                "label": "海登生产部"
                            },
                            {
                                "children": [
                                    {
                                        "id": 50015,
                                        "label": "赵洪兵"
                                    },
                                    {
                                        "id": 50018,
                                        "label": "高良"
                                    },
                                    {
                                        "id": 50032,
                                        "label": "卢文广"
                                    },
                                    {
                                        "id": 50040,
                                        "label": "赵云磊"
                                    },
                                    {
                                        "id": 50076,
                                        "label": "程永祥"
                                    }
                                ],
                                "id": 719943262,
                                "label": "海登工程部"
                            }
                        ],
                        "id": 719787525,
                        "label": "海登项目管理中心"
                    }
                ],
                "id": 719615761,
                "label": "海登项目管理板块"
            },
            {
                "children": [
                    {
                        "children": [],
                        "id": 719849387,
                        "label": "北京海登技术部"
                    },
                    {
                        "children": [],
                        "id": 719942364,
                        "label": "北京海登项目部"
                    },
                    {
                        "children": [],
                        "id": 720012161,
                        "label": "北京海登财务部"
                    },
                    {
                        "children": [],
                        "id": 720028136,
                        "label": "北京海登行政人事部"
                    },
                    {
                        "children": [],
                        "id": 720028137,
                        "label": "北京海登商务部"
                    }
                ],
                "id": 719645788,
                "label": "北京海登"
            },
            {
                "children": [
                    {
                        "children": [
                            {
                                "children": [
                                    {
                                        "id": 50012,
                                        "label": "李茂堂"
                                    },
                                    {
                                        "id": 50013,
                                        "label": "葛建秋"
                                    }
                                ],
                                "id": 719590895,
                                "label": "海登工程设计部"
                            },
                            {
                                "children": [
                                    {
                                        "id": 50003,
                                        "label": "周振年"
                                    },
                                    {
                                        "id": 50004,
                                        "label": "贺振刚"
                                    },
                                    {
                                        "id": 50005,
                                        "label": "安亚冲"
                                    },
                                    {
                                        "id": 50006,
                                        "label": "赵良"
                                    },
                                    {
                                        "id": 50007,
                                        "label": "周先红"
                                    },
                                    {
                                        "id": 50017,
                                        "label": "黄金双"
                                    },
                                    {
                                        "id": 50019,
                                        "label": "杨志强"
                                    },
                                    {
                                        "id": 50020,
                                        "label": "陆梁"
                                    },
                                    {
                                        "id": 50021,
                                        "label": "许武德"
                                    },
                                    {
                                        "id": 50022,
                                        "label": "李光年"
                                    },
                                    {
                                        "id": 50036,
                                        "label": "鄢海新"
                                    },
                                    {
                                        "id": 50037,
                                        "label": "刘春艳"
                                    },
                                    {
                                        "id": 50038,
                                        "label": "高阳"
                                    },
                                    {
                                        "id": 50039,
                                        "label": "潘海滨"
                                    },
                                    {
                                        "id": 50080,
                                        "label": "王冲"
                                    },
                                    {
                                        "id": 50081,
                                        "label": "田宝永"
                                    },
                                    {
                                        "id": 50092,
                                        "label": "韩鸿志"
                                    }
                                ],
                                "id": 719761590,
                                "label": "海登技术研发部"
                            }
                        ],
                        "id": 719781583,
                        "label": "海登技术研发中心"
                    }
                ],
                "id": 719688686,
                "label": "海登技术研发板块"
            },
            {
                "children": [
                    {
                        "children": [
                            {
                                "id": 50016,
                                "label": "梁昊"
                            },
                            {
                                "id": 50075,
                                "label": "赵阳林"
                            },
                            {
                                "id": 50077,
                                "label": "贺娜"
                            }
                        ],
                        "id": 719996127,
                        "label": "海登市场部"
                    }
                ],
                "id": 719690660,
                "label": "海登市场板块"
            },
            {
                "children": [
                    {
                        "children": [
                            {
                                "id": 50008,
                                "label": "胡建红"
                            },
                            {
                                "id": 50009,
                                "label": "朱丽萍"
                            },
                            {
                                "id": 50010,
                                "label": "李敏峰"
                            },
                            {
                                "id": 50078,
                                "label": "李丽"
                            }
                        ],
                        "id": 719963141,
                        "label": "海登人事行政部"
                    }
                ],
                "id": 719724538,
                "label": "海登人事行政板块"
            },
            {
                "children": [
                    {
                        "children": [
                            {
                                "id": 50025,
                                "label": "周丽华"
                            },
                            {
                                "id": 50026,
                                "label": "蒋丽娜"
                            },
                            {
                                "id": 50027,
                                "label": "强利琴"
                            },
                            {
                                "id": 50028,
                                "label": "黄澜婷"
                            }
                        ],
                        "id": 719634843,
                        "label": "海登财务部"
                    }
                ],
                "id": 719904382,
                "label": "海登财务板块"
            },
            {
                "children": [
                    {
                        "children": [
                            {
                                "id": 50023,
                                "label": "王林梅"
                            },
                            {
                                "id": 50029,
                                "label": "梁岭生"
                            },
                            {
                                "id": 50030,
                                "label": "徐亮亮"
                            },
                            {
                                "id": 50031,
                                "label": "方洁"
                            },
                            {
                                "id": 50100,
                                "label": "黄书娟"
                            },
                            {
                                "id": 50101,
                                "label": "刘仁祖"
                            }
                        ],
                        "id": 719977201,
                        "label": "海登供应链管理部"
                    }
                ],
                "id": 720014083,
                "label": "海登供应链管理板块"
            },
            {
                "children": [
                    {
                        "children": [
                            {
                                "id": 50045,
                                "label": "谢建康"
                            }
                        ],
                        "id": 720953894,
                        "label": "海登质量管理部"
                    }
                ],
                "id": 727176370,
                "label": "海登质量管理板块"
            },
            {
                "children": [
                    {
                        "children": [
                            {
                                "id": 50002,
                                "label": "谭洪"
                            }
                        ],
                        "id": 726988801,
                        "label": "海登安全管理部"
                    }
                ],
                "id": 727270220,
                "label": "海登安全管理板块"
            },
            {
                "children": [],
                "id": 769211217,
                "label": "海登生产板块"
            },
            {
                "children": [
                    {
                        "id": 50001,
                        "label": "黄志平"
                    }
                ],
                "id": 816576414,
                "label": "海登总经办"
            }
        ],
        "id": 719884337,
        "label": "常州海登赛思涂装设备有限公司"
    },
    {
        "children": [
            {
                "id": 17,
                "label": "张晓军"
            }
        ],
        "id": 726857676,
        "label": "工会"
    },
    {
        "children": [
            {
                "children": [
                    {
                        "id": 19,
                        "label": "荆降杰"
                    }
                ],
                "id": 726876592,
                "label": "审计部"
            }
        ],
        "id": 726943420,
        "label": "审计板块"
    },
    {
        "children": [
            {
                "children": [
                    {
                        "children": [
                            {
                                "id": 797,
                                "label": "唐玉龙"
                            },
                            {
                                "id": 870,
                                "label": "李婉"
                            },
                            {
                                "id": 871,
                                "label": "陈瑾"
                            }
                        ],
                        "id": 601040906,
                        "label": "人力资源部（上海、江苏）"
                    },
                    {
                        "children": [],
                        "id": 608711639,
                        "label": "人力资源部（深圳）"
                    },
                    {
                        "children": [
                            {
                                "id": 85,
                                "label": "赵晓霞"
                            },
                            {
                                "id": 225,
                                "label": "郭姗姗"
                            },
                            {
                                "id": 411,
                                "label": "李佳"
                            },
                            {
                                "id": 486,
                                "label": "贺淑芳"
                            },
                            {
                                "id": 659,
                                "label": "郭琦"
                            },
                            {
                                "id": 661,
                                "label": "董健"
                            },
                            {
                                "id": 805,
                                "label": "李晓琦"
                            },
                            {
                                "id": 858,
                                "label": "徐宏昇"
                            },
                            {
                                "id": 863,
                                "label": "刘惠弘"
                            },
                            {
                                "id": 865,
                                "label": "石晋红"
                            },
                            {
                                "id": 866,
                                "label": "李心悦"
                            }
                        ],
                        "id": 617053092,
                        "label": "人力资源部（太原）"
                    }
                ],
                "id": 184365915,
                "label": "人力资源板块"
            },
            {
                "children": [
                    {
                        "children": [
                            {
                                "id": 25,
                                "label": "裴丽霞"
                            },
                            {
                                "id": 449,
                                "label": "王茜"
                            },
                            {
                                "id": 656,
                                "label": "钱晨"
                            },
                            {
                                "id": 802,
                                "label": "张旖旎"
                            },
                            {
                                "id": 812,
                                "label": "侯佳伟"
                            },
                            {
                                "id": 818,
                                "label": "曹一澜"
                            }
                        ],
                        "id": 617078088,
                        "label": "市场部"
                    }
                ],
                "id": 184367930,
                "label": "市场板块"
            },
            {
                "children": [
                    {
                        "children": [
                            {
                                "id": 71,
                                "label": "郭胜莲"
                            },
                            {
                                "id": 79,
                                "label": "董翠娥"
                            },
                            {
                                "id": 81,
                                "label": "杨琴"
                            },
                            {
                                "id": 82,
                                "label": "王建梅"
                            },
                            {
                                "id": 83,
                                "label": "杜振国"
                            },
                            {
                                "id": 97,
                                "label": "赵静"
                            },
                            {
                                "id": 221,
                                "label": "孟波"
                            },
                            {
                                "id": 389,
                                "label": "尹志宏"
                            },
                            {
                                "id": 435,
                                "label": "史政"
                            },
                            {
                                "id": 462,
                                "label": "常彬杰"
                            },
                            {
                                "id": 501,
                                "label": "高剑荣"
                            },
                            {
                                "id": 623,
                                "label": "李红娟"
                            },
                            {
                                "id": 784,
                                "label": "刘艳峰"
                            },
                            {
                                "id": 862,
                                "label": "刘建男"
                            },
                            {
                                "id": 868,
                                "label": "冀新"
                            },
                            {
                                "id": 873,
                                "label": "王吉芬"
                            },
                            {
                                "id": 879,
                                "label": "刘光莉"
                            },
                            {
                                "id": 880,
                                "label": "武慧敏"
                            }
                        ],
                        "id": 600122537,
                        "label": "财务部（太原）"
                    },
                    {
                        "children": [
                            {
                                "id": 720,
                                "label": "司文静"
                            }
                        ],
                        "id": 704810440,
                        "label": "财务部（山东）"
                    },
                    {
                        "children": [
                            {
                                "id": 548,
                                "label": "汪小美"
                            }
                        ],
                        "id": 704825416,
                        "label": "财务部（深圳）"
                    },
                    {
                        "children": [
                            {
                                "id": 536,
                                "label": "王勇"
                            },
                            {
                                "id": 540,
                                "label": "王子"
                            }
                        ],
                        "id": 705043192,
                        "label": "财务部（上海）"
                    },
                    {
                        "children": [
                            {
                                "id": 711,
                                "label": "陈琳"
                            }
                        ],
                        "id": 726902489,
                        "label": "财务部（江苏）"
                    }
                ],
                "id": 184555645,
                "label": "财务板块"
            },
            {
                "children": [
                    {
                        "children": [
                            {
                                "id": 84,
                                "label": "王照军"
                            },
                            {
                                "id": 154,
                                "label": "郭祝平"
                            },
                            {
                                "id": 256,
                                "label": "李慧"
                            },
                            {
                                "id": 284,
                                "label": "王水平"
                            },
                            {
                                "id": 317,
                                "label": "王利君"
                            },
                            {
                                "id": 330,
                                "label": "安慧刚"
                            },
                            {
                                "id": 490,
                                "label": "冯志强"
                            }
                        ],
                        "id": 600106515,
                        "label": "行政管理部（太原）"
                    },
                    {
                        "children": [
                            {
                                "id": 717,
                                "label": "张洪庆"
                            },
                            {
                                "id": 718,
                                "label": "王瑾"
                            }
                        ],
                        "id": 704607528,
                        "label": "行政管理部（山东）"
                    }
                ],
                "id": 580795160,
                "label": "行政管理板块"
            },
            {
                "children": [
                    {
                        "children": [
                            {
                                "id": 293,
                                "label": "王凌蔚"
                            },
                            {
                                "id": 739,
                                "label": "关卓然"
                            },
                            {
                                "id": 811,
                                "label": "申豪文"
                            },
                            {
                                "id": 830,
                                "label": "测试"
                            }
                        ],
                        "id": 678126725,
                        "label": "信息技术部"
                    }
                ],
                "id": 703475068,
                "label": "信息技术板块"
            },
            {
                "children": [
                    {
                        "children": [
                            {
                                "children": [
                                    {
                                        "children": [
                                            {
                                                "id": 72,
                                                "label": "杨文"
                                            },
                                            {
                                                "id": 132,
                                                "label": "吴晋奎"
                                            },
                                            {
                                                "id": 152,
                                                "label": "王志红"
                                            },
                                            {
                                                "id": 220,
                                                "label": "吕瑞峰"
                                            },
                                            {
                                                "id": 255,
                                                "label": "常雪峰"
                                            },
                                            {
                                                "id": 305,
                                                "label": "闫俊江"
                                            },
                                            {
                                                "id": 354,
                                                "label": "高来喜"
                                            },
                                            {
                                                "id": 409,
                                                "label": "王瑶瑶"
                                            },
                                            {
                                                "id": 421,
                                                "label": "翟国京"
                                            },
                                            {
                                                "id": 707,
                                                "label": "李重庆"
                                            },
                                            {
                                                "id": 813,
                                                "label": "王鑫"
                                            }
                                        ],
                                        "id": 601784015,
                                        "label": "质检室"
                                    }
                                ],
                                "id": 601470012,
                                "label": "质量管理部（太原）"
                            }
                        ],
                        "id": 580673270,
                        "label": "质量管理部"
                    }
                ],
                "id": 704651766,
                "label": "质量管理板块"
            },
            {
                "children": [
                    {
                        "children": [],
                        "id": 580812042,
                        "label": "战略发展部"
                    }
                ],
                "id": 704780463,
                "label": "战略发展板块"
            },
            {
                "children": [
                    {
                        "children": [
                            {
                                "id": 370,
                                "label": "贾欣悦"
                            },
                            {
                                "id": 673,
                                "label": "卫思奇"
                            },
                            {
                                "id": 843,
                                "label": "马天宇"
                            },
                            {
                                "id": 844,
                                "label": "饶胜飞"
                            },
                            {
                                "id": 845,
                                "label": "程沛"
                            },
                            {
                                "id": 850,
                                "label": "高波"
                            }
                        ],
                        "id": 580158806,
                        "label": "总经理办公室"
                    }
                ],
                "id": 704824516,
                "label": "总经理办公室板块"
            },
            {
                "children": [
                    {
                        "children": [
                            {
                                "id": 164,
                                "label": "郝玉强"
                            },
                            {
                                "id": 189,
                                "label": "王孝良"
                            },
                            {
                                "id": 636,
                                "label": "王寅霞"
                            },
                            {
                                "id": 831,
                                "label": "王鹏"
                            },
                            {
                                "id": 846,
                                "label": "舒成亮"
                            },
                            {
                                "id": 878,
                                "label": "史学锋"
                            },
                            {
                                "id": 887,
                                "label": "姚国红"
                            },
                            {
                                "id": 895,
                                "label": "任金彪"
                            },
                            {
                                "id": 63019,
                                "label": "王鹏飞"
                            },
                            {
                                "id": 63020,
                                "label": "孟兆琨"
                            }
                        ],
                        "id": 580414438,
                        "label": "安全管理部"
                    }
                ],
                "id": 704992463,
                "label": "安全管理板块"
            },
            {
                "children": [
                    {
                        "children": [
                            {
                                "id": 307,
                                "label": "胡晨阳"
                            },
                            {
                                "id": 478,
                                "label": "冯海潇"
                            },
                            {
                                "id": 651,
                                "label": "孙鹤"
                            }
                        ],
                        "id": 184363996,
                        "label": "证券部"
                    }
                ],
                "id": 705025237,
                "label": "证券板块"
            },
            {
                "children": [],
                "id": 822196822,
                "label": "研究院"
            }
        ],
        "id": 822047557,
        "label": "集团职能部门"
    },
    {
        "children": [],
        "id": 822211485,
        "label": "常州利润中心"
    },
    {
        "children": [
            {
                "children": [
                    {
                        "children": [
                            {
                                "id": 60,
                                "label": "李洪昌"
                            },
                            {
                                "id": 184,
                                "label": "贾勇平"
                            },
                            {
                                "id": 194,
                                "label": "苗鑫"
                            },
                            {
                                "id": 247,
                                "label": "张俊甲"
                            },
                            {
                                "id": 253,
                                "label": "郝岳强"
                            },
                            {
                                "id": 281,
                                "label": "刘云峰"
                            },
                            {
                                "id": 304,
                                "label": "李军胜"
                            },
                            {
                                "id": 406,
                                "label": "郭超"
                            },
                            {
                                "id": 453,
                                "label": "王德才"
                            },
                            {
                                "id": 477,
                                "label": "赵惠文"
                            },
                            {
                                "id": 502,
                                "label": "牛锋军"
                            },
                            {
                                "id": 578,
                                "label": "贾庆章"
                            },
                            {
                                "id": 591,
                                "label": "刘金鑫"
                            },
                            {
                                "id": 593,
                                "label": "王凯伟"
                            },
                            {
                                "id": 631,
                                "label": "李少斌"
                            },
                            {
                                "id": 633,
                                "label": "张天宇"
                            },
                            {
                                "id": 646,
                                "label": "巩晓恩"
                            },
                            {
                                "id": 667,
                                "label": "史志奇"
                            },
                            {
                                "id": 669,
                                "label": "赵亮"
                            },
                            {
                                "id": 671,
                                "label": "关志成"
                            },
                            {
                                "id": 672,
                                "label": "闫智涛"
                            },
                            {
                                "id": 695,
                                "label": "弓嘉树"
                            },
                            {
                                "id": 702,
                                "label": "郝宇辰"
                            },
                            {
                                "id": 735,
                                "label": "祁浩杰"
                            },
                            {
                                "id": 741,
                                "label": "许子豪"
                            },
                            {
                                "id": 746,
                                "label": "李宸衍"
                            },
                            {
                                "id": 749,
                                "label": "张岩"
                            },
                            {
                                "id": 752,
                                "label": "吴军"
                            },
                            {
                                "id": 754,
                                "label": "马飞"
                            },
                            {
                                "id": 760,
                                "label": "申文浩"
                            },
                            {
                                "id": 761,
                                "label": "王鑫才"
                            },
                            {
                                "id": 762,
                                "label": "柴钢"
                            },
                            {
                                "id": 765,
                                "label": "尹俊华"
                            },
                            {
                                "id": 768,
                                "label": "乔健"
                            },
                            {
                                "id": 803,
                                "label": "宋澳祥"
                            },
                            {
                                "id": 814,
                                "label": "赵志艳"
                            },
                            {
                                "id": 888,
                                "label": "方祖华"
                            },
                            {
                                "id": 890,
                                "label": "李江华"
                            },
                            {
                                "id": 901,
                                "label": "李志伟"
                            }
                        ],
                        "id": 580212918,
                        "label": "SA技术部"
                    },
                    {
                        "children": [
                            {
                                "children": [
                                    {
                                        "id": 483,
                                        "label": "杨守明"
                                    },
                                    {
                                        "id": 602,
                                        "label": "张烨"
                                    },
                                    {
                                        "id": 621,
                                        "label": "张梦朝"
                                    },
                                    {
                                        "id": 635,
                                        "label": "郭文豪"
                                    },
                                    {
                                        "id": 800,
                                        "label": "韩捷"
                                    }
                                ],
                                "id": 600064423,
                                "label": "机械设计室"
                            },
                            {
                                "children": [
                                    {
                                        "id": 534,
                                        "label": "于登峰"
                                    },
                                    {
                                        "id": 592,
                                        "label": "周晓峰"
                                    },
                                    {
                                        "id": 605,
                                        "label": "陈龙"
                                    }
                                ],
                                "id": 600157442,
                                "label": "嵌入式软件室"
                            },
                            {
                                "children": [
                                    {
                                        "id": 355,
                                        "label": "郭耀"
                                    },
                                    {
                                        "id": 369,
                                        "label": "何少清"
                                    },
                                    {
                                        "id": 598,
                                        "label": "李飞"
                                    }
                                ],
                                "id": 600663520,
                                "label": "调度软件室"
                            }
                        ],
                        "id": 580398521,
                        "label": "AGV技术研发部"
                    },
                    {
                        "children": [
                            {
                                "children": [
                                    {
                                        "id": 109,
                                        "label": "陈文学"
                                    },
                                    {
                                        "id": 174,
                                        "label": "张世荣"
                                    },
                                    {
                                        "id": 364,
                                        "label": "牛润凯"
                                    },
                                    {
                                        "id": 525,
                                        "label": "申杰"
                                    }
                                ],
                                "id": 599957622,
                                "label": "设计一室"
                            },
                            {
                                "children": [
                                    {
                                        "id": 181,
                                        "label": "贾金凤"
                                    },
                                    {
                                        "id": 235,
                                        "label": "李波涛"
                                    },
                                    {
                                        "id": 419,
                                        "label": "王东"
                                    }
                                ],
                                "id": 601829272,
                                "label": "设计二室"
                            }
                        ],
                        "id": 580411544,
                        "label": "RD研发部"
                    },
                    {
                        "children": [
                            {
                                "children": [
                                    {
                                        "id": 38,
                                        "label": "刘建民"
                                    },
                                    {
                                        "id": 192,
                                        "label": "王哲"
                                    },
                                    {
                                        "id": 223,
                                        "label": "孙亮"
                                    },
                                    {
                                        "id": 299,
                                        "label": "张亮"
                                    },
                                    {
                                        "id": 326,
                                        "label": "江鹏"
                                    },
                                    {
                                        "id": 345,
                                        "label": "周妍"
                                    },
                                    {
                                        "id": 365,
                                        "label": "张洁"
                                    },
                                    {
                                        "id": 663,
                                        "label": "李旭"
                                    },
                                    {
                                        "id": 693,
                                        "label": "续嘉俊"
                                    }
                                ],
                                "id": 595236251,
                                "label": "仿真室"
                            },
                            {
                                "children": [
                                    {
                                        "id": 44,
                                        "label": "景俊亮"
                                    },
                                    {
                                        "id": 143,
                                        "label": "邢跃华"
                                    },
                                    {
                                        "id": 240,
                                        "label": "耿强"
                                    },
                                    {
                                        "id": 246,
                                        "label": "王杰"
                                    },
                                    {
                                        "id": 258,
                                        "label": "李文军"
                                    },
                                    {
                                        "id": 311,
                                        "label": "焦佳平"
                                    },
                                    {
                                        "id": 312,
                                        "label": "胡志鹏"
                                    },
                                    {
                                        "id": 313,
                                        "label": "张嘉敏"
                                    },
                                    {
                                        "id": 335,
                                        "label": "温鹏英"
                                    },
                                    {
                                        "id": 352,
                                        "label": "赵毅"
                                    },
                                    {
                                        "id": 390,
                                        "label": "盖晓捷"
                                    },
                                    {
                                        "id": 393,
                                        "label": "李文杰"
                                    },
                                    {
                                        "id": 394,
                                        "label": "武力强"
                                    },
                                    {
                                        "id": 395,
                                        "label": "李云龙"
                                    },
                                    {
                                        "id": 396,
                                        "label": "孟勇毅"
                                    },
                                    {
                                        "id": 401,
                                        "label": "李富龙"
                                    },
                                    {
                                        "id": 405,
                                        "label": "白峰"
                                    },
                                    {
                                        "id": 416,
                                        "label": "刘文华"
                                    },
                                    {
                                        "id": 417,
                                        "label": "吴卫波"
                                    },
                                    {
                                        "id": 468,
                                        "label": "闫岩"
                                    },
                                    {
                                        "id": 494,
                                        "label": "田伦"
                                    },
                                    {
                                        "id": 580,
                                        "label": "刘亨"
                                    },
                                    {
                                        "id": 599,
                                        "label": "谢宏博"
                                    },
                                    {
                                        "id": 609,
                                        "label": "贾禹"
                                    },
                                    {
                                        "id": 664,
                                        "label": "侯彦兵"
                                    },
                                    {
                                        "id": 675,
                                        "label": "李婉茹"
                                    },
                                    {
                                        "id": 715,
                                        "label": "马少卓"
                                    },
                                    {
                                        "id": 726,
                                        "label": "陈俊"
                                    },
                                    {
                                        "id": 727,
                                        "label": "邢婷婷"
                                    },
                                    {
                                        "id": 731,
                                        "label": "杨文斌"
                                    },
                                    {
                                        "id": 742,
                                        "label": "于拓宇"
                                    },
                                    {
                                        "id": 763,
                                        "label": "宿晓鹏"
                                    },
                                    {
                                        "id": 778,
                                        "label": "裴韶禹"
                                    },
                                    {
                                        "id": 779,
                                        "label": "姚昊天"
                                    },
                                    {
                                        "id": 781,
                                        "label": "李佳蓓"
                                    },
                                    {
                                        "id": 782,
                                        "label": "李田君"
                                    },
                                    {
                                        "id": 795,
                                        "label": "郑文俊"
                                    },
                                    {
                                        "id": 804,
                                        "label": "刘涛"
                                    },
                                    {
                                        "id": 807,
                                        "label": "张建坦"
                                    },
                                    {
                                        "id": 819,
                                        "label": "李文韬"
                                    },
                                    {
                                        "id": 822,
                                        "label": "李雪祥"
                                    },
                                    {
                                        "id": 823,
                                        "label": "李冰洋"
                                    },
                                    {
                                        "id": 832,
                                        "label": "王李强"
                                    },
                                    {
                                        "id": 854,
                                        "label": "薛鑫"
                                    },
                                    {
                                        "id": 860,
                                        "label": "方义"
                                    },
                                    {
                                        "id": 893,
                                        "label": "杨伊萍"
                                    },
                                    {
                                        "id": 902,
                                        "label": "王磊"
                                    }
                                ],
                                "id": 595674098,
                                "label": "软件开发部"
                            }
                        ],
                        "id": 580496485,
                        "label": "软件公司"
                    },
                    {
                        "children": [
                            {
                                "children": [
                                    {
                                        "id": 50,
                                        "label": "王振才"
                                    },
                                    {
                                        "id": 55,
                                        "label": "夏中华"
                                    },
                                    {
                                        "id": 68,
                                        "label": "史源源"
                                    },
                                    {
                                        "id": 155,
                                        "label": "胡晓华"
                                    },
                                    {
                                        "id": 159,
                                        "label": "张旺军"
                                    },
                                    {
                                        "id": 234,
                                        "label": "付东凯"
                                    },
                                    {
                                        "id": 257,
                                        "label": "李美军"
                                    },
                                    {
                                        "id": 260,
                                        "label": "刘宁"
                                    },
                                    {
                                        "id": 367,
                                        "label": "张李鹏"
                                    },
                                    {
                                        "id": 530,
                                        "label": "郭广乐"
                                    },
                                    {
                                        "id": 579,
                                        "label": "李鑫"
                                    }
                                ],
                                "id": 600033494,
                                "label": "FAE"
                            },
                            {
                                "children": [
                                    {
                                        "id": 229,
                                        "label": "赵永兵"
                                    },
                                    {
                                        "id": 292,
                                        "label": "毛强强"
                                    },
                                    {
                                        "id": 576,
                                        "label": "梁小伟"
                                    },
                                    {
                                        "id": 589,
                                        "label": "郭瑞锋"
                                    },
                                    {
                                        "id": 596,
                                        "label": "王聚将"
                                    },
                                    {
                                        "id": 625,
                                        "label": "史彦军"
                                    }
                                ],
                                "id": 600069582,
                                "label": "PAE"
                            },
                            {
                                "children": [
                                    {
                                        "id": 118,
                                        "label": "李德强"
                                    },
                                    {
                                        "id": 179,
                                        "label": "王进飞"
                                    },
                                    {
                                        "id": 201,
                                        "label": "王彦宁"
                                    },
                                    {
                                        "id": 212,
                                        "label": "王柱"
                                    },
                                    {
                                        "id": 264,
                                        "label": "张飞飞"
                                    },
                                    {
                                        "id": 269,
                                        "label": "胡永旺"
                                    },
                                    {
                                        "id": 277,
                                        "label": "郝秀峰"
                                    },
                                    {
                                        "id": 285,
                                        "label": "马延贵"
                                    },
                                    {
                                        "id": 286,
                                        "label": "李晓奇"
                                    },
                                    {
                                        "id": 306,
                                        "label": "冯伟"
                                    },
                                    {
                                        "id": 432,
                                        "label": "李宇星"
                                    },
                                    {
                                        "id": 466,
                                        "label": "冯毅"
                                    },
                                    {
                                        "id": 482,
                                        "label": "伊兴伟"
                                    },
                                    {
                                        "id": 587,
                                        "label": "张陈"
                                    },
                                    {
                                        "id": 611,
                                        "label": "张经"
                                    },
                                    {
                                        "id": 769,
                                        "label": "贾栋"
                                    }
                                ],
                                "id": 600707733,
                                "label": "SAE"
                            },
                            {
                                "children": [
                                    {
                                        "id": 144,
                                        "label": "郝毅"
                                    },
                                    {
                                        "id": 379,
                                        "label": "王仁俊"
                                    },
                                    {
                                        "id": 392,
                                        "label": "仝洲"
                                    }
                                ],
                                "id": 601499263,
                                "label": "RDE"
                            },
                            {
                                "children": [
                                    {
                                        "id": 610,
                                        "label": "张钢"
                                    },
                                    {
                                        "id": 640,
                                        "label": "苗茂"
                                    },
                                    {
                                        "id": 674,
                                        "label": "王一力"
                                    },
                                    {
                                        "id": 705,
                                        "label": "邓志伟"
                                    },
                                    {
                                        "id": 712,
                                        "label": "郭晓"
                                    },
                                    {
                                        "id": 736,
                                        "label": "刘岩"
                                    },
                                    {
                                        "id": 740,
                                        "label": "张宏亮"
                                    },
                                    {
                                        "id": 747,
                                        "label": "胡小伟"
                                    },
                                    {
                                        "id": 748,
                                        "label": "白洪源"
                                    },
                                    {
                                        "id": 753,
                                        "label": "李帆"
                                    },
                                    {
                                        "id": 780,
                                        "label": "汪兴伟"
                                    },
                                    {
                                        "id": 809,
                                        "label": "谷凯盛"
                                    }
                                ],
                                "id": 658681789,
                                "label": "ECE"
                            }
                        ],
                        "id": 580502461,
                        "label": "ETD电控技术部"
                    },
                    {
                        "children": [
                            {
                                "id": 7,
                                "label": "成立平"
                            },
                            {
                                "id": 35,
                                "label": "王建春"
                            },
                            {
                                "id": 41,
                                "label": "闫建中"
                            },
                            {
                                "id": 51,
                                "label": "郑建民"
                            },
                            {
                                "id": 153,
                                "label": "樊雷"
                            },
                            {
                                "id": 226,
                                "label": "韩玉茂"
                            },
                            {
                                "id": 302,
                                "label": "郝建新"
                            },
                            {
                                "id": 460,
                                "label": "刘振"
                            },
                            {
                                "id": 464,
                                "label": "孟璐瑜"
                            },
                            {
                                "id": 485,
                                "label": "李耿"
                            },
                            {
                                "id": 583,
                                "label": "杨国斌"
                            },
                            {
                                "id": 616,
                                "label": "程晓阳"
                            },
                            {
                                "id": 629,
                                "label": "成超辉"
                            },
                            {
                                "id": 751,
                                "label": "李欣桓"
                            },
                            {
                                "id": 776,
                                "label": "李昊燃"
                            }
                        ],
                        "id": 580533494,
                        "label": "FA技术部"
                    },
                    {
                        "children": [
                            {
                                "id": 34,
                                "label": "吉王盛"
                            },
                            {
                                "id": 195,
                                "label": "杜瑞林"
                            },
                            {
                                "id": 340,
                                "label": "杜平"
                            },
                            {
                                "id": 469,
                                "label": "李飞龙"
                            },
                            {
                                "id": 516,
                                "label": "陈泽营"
                            },
                            {
                                "id": 518,
                                "label": "马梁丁"
                            },
                            {
                                "id": 531,
                                "label": "张天"
                            },
                            {
                                "id": 626,
                                "label": "康炳煜"
                            },
                            {
                                "id": 666,
                                "label": "杨耀荣"
                            }
                        ],
                        "id": 580852019,
                        "label": "PA技术部"
                    },
                    {
                        "children": [
                            {
                                "id": 654,
                                "label": "陈伟"
                            },
                            {
                                "id": 683,
                                "label": "张如洋"
                            },
                            {
                                "id": 685,
                                "label": "林志杰"
                            },
                            {
                                "id": 686,
                                "label": "陈志鹏"
                            },
                            {
                                "id": 688,
                                "label": "何振威"
                            },
                            {
                                "id": 689,
                                "label": "郭巍"
                            },
                            {
                                "id": 690,
                                "label": "王吉庆"
                            },
                            {
                                "id": 723,
                                "label": "刘朝彬"
                            },
                            {
                                "id": 724,
                                "label": "刘守焜"
                            },
                            {
                                "id": 757,
                                "label": "李宗财"
                            },
                            {
                                "id": 758,
                                "label": "李烨"
                            },
                            {
                                "id": 759,
                                "label": "肖鸿坤"
                            },
                            {
                                "id": 810,
                                "label": "秦菲菲"
                            }
                        ],
                        "id": 619451065,
                        "label": "软件开发部（深圳）"
                    },
                    {
                        "children": [
                            {
                                "id": 280,
                                "label": "薄靖涛"
                            },
                            {
                                "id": 422,
                                "label": "郝文强"
                            },
                            {
                                "id": 476,
                                "label": "王星"
                            },
                            {
                                "id": 657,
                                "label": "杨宗健"
                            },
                            {
                                "id": 665,
                                "label": "崔雪斌"
                            }
                        ],
                        "id": 667361088,
                        "label": "新能源技术部"
                    },
                    {
                        "children": [
                            {
                                "id": 744,
                                "label": "李发鑫"
                            },
                            {
                                "id": 745,
                                "label": "吴庆乐"
                            },
                            {
                                "id": 755,
                                "label": "孙天"
                            },
                            {
                                "id": 756,
                                "label": "芮辉"
                            }
                        ],
                        "id": 691942235,
                        "label": "新能源研发部"
                    }
                ],
                "id": 580380482,
                "label": "技术中心"
            },
            {
                "children": [
                    {
                        "children": [
                            {
                                "children": [
                                    {
                                        "id": 359,
                                        "label": "曹永杰"
                                    },
                                    {
                                        "id": 498,
                                        "label": "刘国成"
                                    }
                                ],
                                "id": 197821866,
                                "label": "生产二部生产处"
                            },
                            {
                                "children": [
                                    {
                                        "id": 42011,
                                        "label": "王伟强"
                                    },
                                    {
                                        "id": 42019,
                                        "label": "李永荣"
                                    },
                                    {
                                        "id": 42027,
                                        "label": "赵磊"
                                    },
                                    {
                                        "id": 42075,
                                        "label": "梁勇胜"
                                    },
                                    {
                                        "id": 42079,
                                        "label": "张继明"
                                    }
                                ],
                                "id": 273323057,
                                "label": "生产二部铆焊一组"
                            },
                            {
                                "children": [
                                    {
                                        "id": 42212,
                                        "label": "蒋志勇"
                                    }
                                ],
                                "id": 273323058,
                                "label": "生产二部板下组"
                            },
                            {
                                "children": [],
                                "id": 273323059,
                                "label": "生产二部型下组"
                            },
                            {
                                "children": [],
                                "id": 273323063,
                                "label": "生产二部发货一组"
                            },
                            {
                                "children": [],
                                "id": 273323064,
                                "label": "生产二部装配一组"
                            },
                            {
                                "children": [
                                    {
                                        "id": 41056,
                                        "label": "周炳良"
                                    },
                                    {
                                        "id": 41076,
                                        "label": "裴志隆"
                                    }
                                ],
                                "id": 273323065,
                                "label": "生产二部铆焊二组（机器人组）"
                            },
                            {
                                "children": [],
                                "id": 273323066,
                                "label": "生产二部涂装组"
                            },
                            {
                                "children": [
                                    {
                                        "id": 267,
                                        "label": "高增"
                                    }
                                ],
                                "id": 290620005,
                                "label": "生产二部维修组"
                            },
                            {
                                "children": [],
                                "id": 412852282,
                                "label": "生产二部发货二组"
                            },
                            {
                                "children": [],
                                "id": 434380073,
                                "label": "生产二部电气组"
                            }
                        ],
                        "id": 197258961,
                        "label": "生产二部"
                    },
                    {
                        "children": [
                            {
                                "id": 90,
                                "label": "林俊玲"
                            },
                            {
                                "id": 91,
                                "label": "任改平"
                            },
                            {
                                "id": 136,
                                "label": "温辉"
                            },
                            {
                                "id": 205,
                                "label": "段炳义"
                            },
                            {
                                "id": 261,
                                "label": "杨小龙"
                            },
                            {
                                "id": 274,
                                "label": "郭鹏宇"
                            },
                            {
                                "id": 385,
                                "label": "陈文明"
                            },
                            {
                                "id": 403,
                                "label": "郑志超"
                            },
                            {
                                "id": 410,
                                "label": "孙楚琪"
                            },
                            {
                                "id": 622,
                                "label": "马文婷"
                            },
                            {
                                "id": 627,
                                "label": "杨菲"
                            },
                            {
                                "id": 634,
                                "label": "任道宇"
                            },
                            {
                                "id": 653,
                                "label": "刘煜"
                            },
                            {
                                "id": 750,
                                "label": "郝松生"
                            },
                            {
                                "id": 806,
                                "label": "白旭"
                            }
                        ],
                        "id": 580080995,
                        "label": "项目管理部"
                    },
                    {
                        "children": [
                            {
                                "children": [
                                    {
                                        "id": 13,
                                        "label": "景瑞"
                                    },
                                    {
                                        "id": 126,
                                        "label": "杨山"
                                    },
                                    {
                                        "id": 172,
                                        "label": "要春兰"
                                    },
                                    {
                                        "id": 217,
                                        "label": "杨桃梨"
                                    },
                                    {
                                        "id": 268,
                                        "label": "韩红江"
                                    },
                                    {
                                        "id": 275,
                                        "label": "赵文潮"
                                    },
                                    {
                                        "id": 386,
                                        "label": "郝志红"
                                    }
                                ],
                                "id": 601481005,
                                "label": "生产一部生产处"
                            },
                            {
                                "children": [
                                    {
                                        "id": 244,
                                        "label": "陈东跃"
                                    },
                                    {
                                        "id": 342,
                                        "label": "薛晋峰"
                                    },
                                    {
                                        "id": 511,
                                        "label": "王有明"
                                    }
                                ],
                                "id": 640829397,
                                "label": "生产一部外协组"
                            },
                            {
                                "children": [
                                    {
                                        "id": 20016,
                                        "label": "刘玉勤"
                                    },
                                    {
                                        "id": 20178,
                                        "label": "潘瑞军"
                                    },
                                    {
                                        "id": 20280,
                                        "label": "刘海江"
                                    },
                                    {
                                        "id": 20289,
                                        "label": "冀小佳"
                                    },
                                    {
                                        "id": 20315,
                                        "label": "陈昀辉"
                                    },
                                    {
                                        "id": 20617,
                                        "label": "程建军"
                                    }
                                ],
                                "id": 817520969,
                                "label": "生产一部下料组"
                            },
                            {
                                "children": [
                                    {
                                        "id": 20009,
                                        "label": "李春生"
                                    },
                                    {
                                        "id": 20023,
                                        "label": "白俊峰"
                                    }
                                ],
                                "id": 817635687,
                                "label": "生产一部装配组"
                            },
                            {
                                "children": [
                                    {
                                        "id": 20228,
                                        "label": "李旭"
                                    },
                                    {
                                        "id": 20734,
                                        "label": "李亚栋"
                                    }
                                ],
                                "id": 817988491,
                                "label": "生产一部机加组"
                            },
                            {
                                "children": [
                                    {
                                        "id": 20002,
                                        "label": "李飞"
                                    },
                                    {
                                        "id": 20011,
                                        "label": "王宝明"
                                    },
                                    {
                                        "id": 20015,
                                        "label": "王怀厚"
                                    },
                                    {
                                        "id": 20018,
                                        "label": "程永军"
                                    },
                                    {
                                        "id": 20027,
                                        "label": "刘颜兵"
                                    },
                                    {
                                        "id": 20036,
                                        "label": "黄步俊"
                                    },
                                    {
                                        "id": 20040,
                                        "label": "郝宝涛"
                                    },
                                    {
                                        "id": 20058,
                                        "label": "白永红"
                                    },
                                    {
                                        "id": 20061,
                                        "label": "李好全"
                                    },
                                    {
                                        "id": 20067,
                                        "label": "周建清"
                                    },
                                    {
                                        "id": 20069,
                                        "label": "周顺"
                                    },
                                    {
                                        "id": 20071,
                                        "label": "张永桢"
                                    },
                                    {
                                        "id": 20092,
                                        "label": "刘卫东"
                                    },
                                    {
                                        "id": 20102,
                                        "label": "尹晓勇"
                                    },
                                    {
                                        "id": 20194,
                                        "label": "黄步谦"
                                    },
                                    {
                                        "id": 20389,
                                        "label": "祁晓忠"
                                    },
                                    {
                                        "id": 20429,
                                        "label": "安永明"
                                    },
                                    {
                                        "id": 20541,
                                        "label": "李建华"
                                    }
                                ],
                                "id": 818162291,
                                "label": "生产一部铆焊组"
                            },
                            {
                                "children": [
                                    {
                                        "id": 20031,
                                        "label": "潘清"
                                    },
                                    {
                                        "id": 21024,
                                        "label": "乔培光"
                                    },
                                    {
                                        "id": 21039,
                                        "label": "白肉肉"
                                    },
                                    {
                                        "id": 21057,
                                        "label": "刘丁"
                                    }
                                ],
                                "id": 818204250,
                                "label": "生产一部焊工组"
                            },
                            {
                                "children": [
                                    {
                                        "id": 21002,
                                        "label": "张照峰"
                                    }
                                ],
                                "id": 818248060,
                                "label": "生产一部轧机组"
                            }
                        ],
                        "id": 580323648,
                        "label": "生产一部"
                    },
                    {
                        "children": [
                            {
                                "id": 58,
                                "label": "勾金平"
                            },
                            {
                                "id": 177,
                                "label": "冯飞"
                            },
                            {
                                "id": 199,
                                "label": "高伟"
                            },
                            {
                                "id": 594,
                                "label": "白荣"
                            },
                            {
                                "id": 655,
                                "label": "吕忠伟"
                            },
                            {
                                "id": 881,
                                "label": "郭力华"
                            },
                            {
                                "id": 882,
                                "label": "付东亮"
                            },
                            {
                                "id": 891,
                                "label": "刘坤"
                            },
                            {
                                "id": 900,
                                "label": "金宏波"
                            },
                            {
                                "id": 30005,
                                "label": "孙伟"
                            },
                            {
                                "id": 30008,
                                "label": "兰贵明"
                            },
                            {
                                "id": 30009,
                                "label": "刘胜利"
                            },
                            {
                                "id": 30010,
                                "label": "庄西东"
                            },
                            {
                                "id": 30012,
                                "label": "张青旗"
                            },
                            {
                                "id": 30014,
                                "label": "于庆"
                            },
                            {
                                "id": 30018,
                                "label": "傅建军"
                            },
                            {
                                "id": 30026,
                                "label": "张忠海"
                            },
                            {
                                "id": 30029,
                                "label": "王玉年"
                            },
                            {
                                "id": 30035,
                                "label": "陈培肖"
                            },
                            {
                                "id": 30036,
                                "label": "王乐民"
                            },
                            {
                                "id": 30050,
                                "label": "赵金玉"
                            },
                            {
                                "id": 30053,
                                "label": "陈文亮"
                            },
                            {
                                "id": 30056,
                                "label": "孙海峰"
                            },
                            {
                                "id": 30058,
                                "label": "殷建红"
                            },
                            {
                                "id": 30067,
                                "label": "刘晓光"
                            },
                            {
                                "id": 30124,
                                "label": "杨贵兵"
                            },
                            {
                                "id": 30191,
                                "label": "刘学世"
                            },
                            {
                                "id": 30201,
                                "label": "赵军"
                            },
                            {
                                "id": 30300,
                                "label": "赵高成"
                            },
                            {
                                "id": 30388,
                                "label": "陈卫江"
                            },
                            {
                                "id": 30487,
                                "label": "刘二鹏"
                            },
                            {
                                "id": 30520,
                                "label": "梁鹏翔"
                            },
                            {
                                "id": 30645,
                                "label": "庄欣"
                            }
                        ],
                        "id": 580662304,
                        "label": "工程部"
                    },
                    {
                        "children": [
                            {
                                "id": 16,
                                "label": "谢晋鹏"
                            },
                            {
                                "id": 93,
                                "label": "张翼凤"
                            },
                            {
                                "id": 94,
                                "label": "齐文斌"
                            },
                            {
                                "id": 99,
                                "label": "魏忠林"
                            },
                            {
                                "id": 104,
                                "label": "赵军旗"
                            },
                            {
                                "id": 224,
                                "label": "许小玲"
                            },
                            {
                                "id": 227,
                                "label": "宋学强"
                            },
                            {
                                "id": 230,
                                "label": "董琴"
                            },
                            {
                                "id": 301,
                                "label": "张鹏"
                            },
                            {
                                "id": 346,
                                "label": "刘文"
                            },
                            {
                                "id": 510,
                                "label": "姜浩文"
                            },
                            {
                                "id": 658,
                                "label": "薛烨"
                            },
                            {
                                "id": 684,
                                "label": "陈倩倩"
                            },
                            {
                                "id": 732,
                                "label": "秦子慧"
                            },
                            {
                                "id": 777,
                                "label": "闫于海"
                            }
                        ],
                        "id": 580730235,
                        "label": "供应链管理部（太原）"
                    },
                    {
                        "children": [
                            {
                                "id": 446,
                                "label": "李晓兵"
                            },
                            {
                                "id": 537,
                                "label": "葛贞帅"
                            }
                        ],
                        "id": 599525702,
                        "label": "工程部（分拣业务）"
                    },
                    {
                        "children": [
                            {
                                "id": 294,
                                "label": "张翔龙"
                            },
                            {
                                "id": 538,
                                "label": "徐国宇"
                            },
                            {
                                "id": 539,
                                "label": "石东戈"
                            },
                            {
                                "id": 708,
                                "label": "刘龙飞"
                            },
                            {
                                "id": 709,
                                "label": "施建明"
                            },
                            {
                                "id": 710,
                                "label": "王瑞琛"
                            }
                        ],
                        "id": 653048617,
                        "label": "新能源&海外项目管理部"
                    },
                    {
                        "children": [
                            {
                                "id": 647,
                                "label": "刘志鹏"
                            },
                            {
                                "id": 676,
                                "label": "丁国强"
                            }
                        ],
                        "id": 653375702,
                        "label": "项目管理部（总包项目）"
                    },
                    {
                        "children": [
                            {
                                "children": [
                                    {
                                        "id": 40,
                                        "label": "尹海兵"
                                    },
                                    {
                                        "id": 75,
                                        "label": "冯月成"
                                    },
                                    {
                                        "id": 338,
                                        "label": "李建斌"
                                    },
                                    {
                                        "id": 577,
                                        "label": "郭宇鹏"
                                    }
                                ],
                                "id": 197613948,
                                "label": "工艺处（生产二部）"
                            },
                            {
                                "children": [
                                    {
                                        "id": 30,
                                        "label": "赵永前"
                                    },
                                    {
                                        "id": 59,
                                        "label": "刘建强"
                                    },
                                    {
                                        "id": 102,
                                        "label": "申路勇"
                                    },
                                    {
                                        "id": 149,
                                        "label": "张伟"
                                    },
                                    {
                                        "id": 171,
                                        "label": "孙涛"
                                    },
                                    {
                                        "id": 251,
                                        "label": "靳蕾蕾"
                                    },
                                    {
                                        "id": 388,
                                        "label": "卫乾"
                                    }
                                ],
                                "id": 598547524,
                                "label": "工艺处（生产一部）"
                            }
                        ],
                        "id": 654409370,
                        "label": "工艺处"
                    },
                    {
                        "children": [],
                        "id": 692260460,
                        "label": "生产管理（江苏）"
                    },
                    {
                        "children": [],
                        "id": 704810812,
                        "label": "供应链管理部（江苏）"
                    }
                ],
                "id": 580813079,
                "label": "项目管理中心"
            },
            {
                "children": [
                    {
                        "children": [
                            {
                                "children": [
                                    {
                                        "children": [
                                            {
                                                "id": 570,
                                                "label": "王晋林"
                                            }
                                        ],
                                        "id": 597991419,
                                        "label": "SA华南销售三部"
                                    },
                                    {
                                        "children": [
                                            {
                                                "id": 543,
                                                "label": "王峰"
                                            },
                                            {
                                                "id": 550,
                                                "label": "周志龙"
                                            },
                                            {
                                                "id": 568,
                                                "label": "章帅"
                                            }
                                        ],
                                        "id": 598873411,
                                        "label": "SA华南销售一部"
                                    }
                                ],
                                "id": 598138324,
                                "label": "SA华南大区"
                            },
                            {
                                "children": [
                                    {
                                        "children": [
                                            {
                                                "id": 458,
                                                "label": "吕兵"
                                            }
                                        ],
                                        "id": 597971577,
                                        "label": "SA华东销售一部"
                                    },
                                    {
                                        "children": [
                                            {
                                                "id": 66,
                                                "label": "胡利明"
                                            }
                                        ],
                                        "id": 598747559,
                                        "label": "SA华东销售二部"
                                    }
                                ],
                                "id": 598610306,
                                "label": "SA华东大区"
                            },
                            {
                                "children": [
                                    {
                                        "children": [
                                            {
                                                "id": 73,
                                                "label": "冀万元"
                                            }
                                        ],
                                        "id": 597933776,
                                        "label": "SA华北销售二部"
                                    },
                                    {
                                        "children": [
                                            {
                                                "id": 162,
                                                "label": "侯晋雷"
                                            }
                                        ],
                                        "id": 705129187,
                                        "label": "SA华北销售一部"
                                    }
                                ],
                                "id": 599107440,
                                "label": "SA华北大区"
                            },
                            {
                                "children": [
                                    {
                                        "id": 448,
                                        "label": "魏东旭"
                                    }
                                ],
                                "id": 599346437,
                                "label": "SA冷链物流业务部"
                            },
                            {
                                "children": [
                                    {
                                        "children": [
                                            {
                                                "id": 545,
                                                "label": "李斯鹏"
                                            },
                                            {
                                                "id": 558,
                                                "label": "许建良"
                                            },
                                            {
                                                "id": 560,
                                                "label": "陈江业"
                                            },
                                            {
                                                "id": 561,
                                                "label": "刘思恩"
                                            },
                                            {
                                                "id": 698,
                                                "label": "韩振华"
                                            },
                                            {
                                                "id": 722,
                                                "label": "杨光"
                                            }
                                        ],
                                        "id": 599240563,
                                        "label": "SA规划四室（深圳）"
                                    },
                                    {
                                        "children": [
                                            {
                                                "id": 546,
                                                "label": "钟维"
                                            },
                                            {
                                                "id": 678,
                                                "label": "李宇航"
                                            }
                                        ],
                                        "id": 599308530,
                                        "label": "SA规划五室（深圳）"
                                    }
                                ],
                                "id": 599370514,
                                "label": "SA规划技术部（四室五室）（深圳）"
                            },
                            {
                                "children": [
                                    {
                                        "children": [
                                            {
                                                "id": 170,
                                                "label": "降晋原"
                                            },
                                            {
                                                "id": 603,
                                                "label": "徐建阳"
                                            },
                                            {
                                                "id": 808,
                                                "label": "师帅"
                                            }
                                        ],
                                        "id": 598120399,
                                        "label": "SA规划一室"
                                    },
                                    {
                                        "children": [
                                            {
                                                "id": 187,
                                                "label": "王建忠"
                                            },
                                            {
                                                "id": 188,
                                                "label": "孙志鹏"
                                            }
                                        ],
                                        "id": 598288691,
                                        "label": "SA规划二室"
                                    },
                                    {
                                        "children": [
                                            {
                                                "id": 134,
                                                "label": "文式轩"
                                            },
                                            {
                                                "id": 209,
                                                "label": "史蒙蒙"
                                            },
                                            {
                                                "id": 291,
                                                "label": "王博"
                                            }
                                        ],
                                        "id": 598625701,
                                        "label": "SA规划三室"
                                    }
                                ],
                                "id": 599679316,
                                "label": "SA规划技术部（一室二室三室）"
                            }
                        ],
                        "id": 579852986,
                        "label": "智能仓储事业部"
                    },
                    {
                        "children": [
                            {
                                "id": 22,
                                "label": "高纯洁"
                            },
                            {
                                "id": 69,
                                "label": "朱生明"
                            },
                            {
                                "id": 74,
                                "label": "张恩"
                            },
                            {
                                "id": 77,
                                "label": "姚飞"
                            }
                        ],
                        "id": 580086922,
                        "label": "客户服务中心"
                    },
                    {
                        "children": [
                            {
                                "children": [
                                    {
                                        "id": 198,
                                        "label": "李伟"
                                    },
                                    {
                                        "id": 315,
                                        "label": "刘晓东"
                                    }
                                ],
                                "id": 598284623,
                                "label": "PA销售二部"
                            },
                            {
                                "children": [
                                    {
                                        "id": 191,
                                        "label": "顾必川"
                                    },
                                    {
                                        "id": 204,
                                        "label": "薛玮"
                                    },
                                    {
                                        "id": 276,
                                        "label": "李晓然"
                                    },
                                    {
                                        "id": 319,
                                        "label": "陈阳"
                                    }
                                ],
                                "id": 598764477,
                                "label": "PA规划技术部"
                            },
                            {
                                "children": [
                                    {
                                        "id": 282,
                                        "label": "赵俊魁"
                                    }
                                ],
                                "id": 598986411,
                                "label": "PA销售三部"
                            },
                            {
                                "children": [
                                    {
                                        "id": 254,
                                        "label": "田乐"
                                    },
                                    {
                                        "id": 279,
                                        "label": "尚腾龙"
                                    }
                                ],
                                "id": 599502483,
                                "label": "PA销售一部"
                            }
                        ],
                        "id": 580110979,
                        "label": "智能停车事业部"
                    },
                    {
                        "children": [
                            {
                                "children": [
                                    {
                                        "id": 438,
                                        "label": "邵鸣杰"
                                    },
                                    {
                                        "id": 451,
                                        "label": "揭刘群"
                                    },
                                    {
                                        "id": 526,
                                        "label": "刘炳聪"
                                    }
                                ],
                                "id": 597967726,
                                "label": "FA销售三部"
                            },
                            {
                                "children": [
                                    {
                                        "id": 27,
                                        "label": "高志杰"
                                    },
                                    {
                                        "id": 29,
                                        "label": "李毅"
                                    },
                                    {
                                        "id": 33,
                                        "label": "张国栋"
                                    },
                                    {
                                        "id": 43,
                                        "label": "朱银栋"
                                    },
                                    {
                                        "id": 147,
                                        "label": "纪常鑫"
                                    },
                                    {
                                        "id": 157,
                                        "label": "冯晓虎"
                                    },
                                    {
                                        "id": 197,
                                        "label": "刘鹏"
                                    },
                                    {
                                        "id": 701,
                                        "label": "翟浩"
                                    }
                                ],
                                "id": 599005536,
                                "label": "FA规划技术部"
                            },
                            {
                                "children": [
                                    {
                                        "id": 9,
                                        "label": "赵勇"
                                    },
                                    {
                                        "id": 11,
                                        "label": "杨秉华"
                                    },
                                    {
                                        "id": 20,
                                        "label": "张海瑞"
                                    }
                                ],
                                "id": 599012550,
                                "label": "FA销售顾问"
                            },
                            {
                                "children": [
                                    {
                                        "id": 76,
                                        "label": "郝锦毅"
                                    },
                                    {
                                        "id": 245,
                                        "label": "王卫"
                                    }
                                ],
                                "id": 599398560,
                                "label": "FA销售二部"
                            },
                            {
                                "children": [
                                    {
                                        "id": 23,
                                        "label": "王剑飞"
                                    },
                                    {
                                        "id": 202,
                                        "label": "张正华"
                                    }
                                ],
                                "id": 659404013,
                                "label": "FA销售一部"
                            }
                        ],
                        "id": 580659272,
                        "label": "智能工厂事业部"
                    }
                ],
                "id": 821973696,
                "label": "营销中心"
            }
        ],
        "id": 822311415,
        "label": "太原利润中心"
    }
]
